Forum Discussion
Adding an index column and log index numbers
Hi, I've created a solution for ETL using Power Query. The solution pulls in data from various sources and does the transform steps and finally uses Append to create an output dataset, which I ca...
v-jingzhang
Community Support
Community SupportHi NimaM
I'm not sure if it's possible to log the last index number in Power Query. Since you plan to upload the output dataset to a database, it may be easier to add an auto increment index column in the database. SQL Auto Increment - Defining Auto Increment Column for a Table (sqltutorial.org)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.