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 exc...
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.