Combine, Merge, and Append

Power Query
21

Hi Ross,

Thanks for the info. I initially thought with Combine I might have to change all the files and not just the master or parameter file but in testing I found as you said just the main initial file will work.

I will also look into what Paul said earlier and creating another query to find the new columns added as looking for the new columns is tedious. I have like 40 columns and
half of them I have the query deleting.

Thanks,

Richard

22

Hi
Just came across this video:


Paul
23

Hi Paul,

I appreciate the follow-up. First view of video, I believe this will help with my ongoing issues as columns are added. I will take a closer look and modify my query the next time I update my file.

Thanks,

Richard