Forum Discussion
Adding an index column and log index numbers
Hi, I've created a solution for ETL using Excel Power Query. The solution pulls in data from various sources and does the transform steps and finally uses Append to create an output dataset, whic...
Perhaps you can create an additional query that pulls the max index from the table and re-use that same query to calculate the index column? I know this creates a circular reference in the queries, but maybe it works?