Power Query, merge 2 or more large files in one

[Remphan]

Help pls with Power Query.

15 local copies of the one original file for filling to the employees.

Next after filling i need combine all files in to one table.

How to do it? And what if there are conflicting data? It is necessary to show in a summary table, which fields and which files there are conflicts, to give these files for rechecking managers. Maybe any example for 2 tables in different files?

 

[Matt Allington]

I have 3 blog posts on the theory and approach. Here is the first one. The others are linked at the bottom of the previous Combine Excel Workbooks with Power Query – Method 1 -

Conflicts need to be managed during import in Power Query. It is impossible to give any more guidance as it is like saying "my car is broken, can you fix it?" With specific information there is no way to answer this question.

 

[Remphan]

I have 3 blog posts on the theory and approach. Here is the first one. The others are linked at the bottom of the previous Combine Excel Workbooks with Power Query – Method 1 -

Conflicts need to be managed during import in Power Query. It is impossible to give any more guidance as it is like saying "my car is broken, can you fix it?" With specific information there is no way to answer this question.

Thank u for the blog posts.

Here is the files - link
Can't attach here directly.

Folder Data. PQ_original.xlsx - original table for filling. Next both files - is filled by emploeyes.

File PQ_all.xlsx - the same as the above three, but in one file for simplify explanation what I need (real data files is very large and located as the example in Data folder. 2-15 files periodically need to combine).

Need combine table 2 and table 3 in table 1. But u can see, that some conflicting data there, highlited. I would be grateful for your help. It's hard to do it yourself. But if you just show it to quickly learn.

 

[Remphan]

Like ur file

But if you imagine that one year only. And each table of a few should complement other. But suddenly there are different data in the same cell, in the different files - it is a conflict, and it should not be.

Once this display to the one who edited the files - has made the adjustments necessary to resolve the conflict.

But how to do this with an example. Flatten multiple files into one. And convenient display that have conflicts so some cells in such a file.

The task is simple - to give each work with a local copy of the file, each brings changes only in itself - but what if they are in conflict. One man made his data and the second made different from the first data...(