Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone.
I managed to consolidate multiple excel files (slave files) into a master file. Whenever I add a new data/row into one of the slave files, the master file will be updated in a new row based from the file source name. Is it possible to change it whereby the new row will appear at the end of the table and not within the file source name?
Thanks!
Solved! Go to Solution.
Hello @mrbuttons07
Power Query can't know when and what was added to your slave-files. So the only way is to find a sort criteria..
Example timestamp when something was added to your slave-file so you can do a final sort.
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
Hi JB,
Thanks JB! Tested out myself and it nearly worked. Gotta learn more about appending rows as that's where I'm stucked at. Thanky you once again!