I have payroll data files which I want to gather into BI. Originally, I was Combining files but additional columns appeared so Combine started giving me issues. Would Merge be a better fit since the files will not be the same. Probably 18 of 20 columns will be the same. The rows will be different with each file as well. Or, should I just manually create one file in Excel through copy / paste to create a file. I would rather automate thru BI Power Query. I want to be able to take the most recent payroll file each week and add to existing BI file.
I have attached a copy of some of the data in the files and highlighted in yellow some of the columns that get added at various times.
Thanks for any recommendations.