Forum Discussion
Automate the Data reconciliation
Hello,
I am new to Power query, so I need some input for the problem which I am trying to solve. I am trying to automate the data reconciliation task which I am doing manually. I have list of excel files (which has lots of sheets) in the folder and have to extract 5th row from different sheet from different excel. so, I want to create a configuration which tells what sheet's row needs to be extracted from each excel and append all the rows. Can you tell me how can I do this in Power query?
thanks in advance,
Sabaresh
2 Replies
Hi sabaresh,
Please refer to the similar case: https://community.powerbi.com/t5/Desktop/Delete-top-rows-from-multiple-imported-files-at-once-and-combin/m-p/310873.
Regards,
Jimmy Tao
Hello Jimmy,
thanks for the response.
As I mentioned in my post, I have multiple sheets in each excel and I don't want to take data from all the sheets. for eg.
I have excel with employee names A, B, C, D, E and each excel have different sheets 1, 2, 3, 4, 5.
I will have a configuration which says A -> 1, B-> 3, C ->3, D -> 4. So the final merged excel will have only data based on configuration.
