Want to merge data coming from 4 excel files in a single master file
Hello guys, I need a suggestion. I have 4 excel files coming from different sources. All these files customer data. I want to combine that data to make a single master customer table in power query. What should be the best way to create a primary key column. I am thinking of generating a random number column and then concatenation it to the customer name. New column generated will be the primary key column. Is this a good one? Please give your opinion and of course if there can be a better option than this. Main problem is that customer column of all the files have different values and no common column to apply merge. I want to combine all sheets to make a master customer data Thanks.
@Amar-Agnihotri Well, your approach will work provided that each of the four files contains only unique customers. But, if you have the same customer in 2 or more files, this approach will essential create duplicates. So, first question, are customers in each of the 4 files truly unique? You might get better performance out of an Index column rather than a random number.