cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Johnsnowlife Helper III
Helper III

What order should I merge and append queries in?

I have multiple queries extracting client data out of excel tables. I eventually need to append all of them together. I also have a ClientNameMap table which maps different spellings of the name of the same person to their ClientID. 

 

Should I merge each initial table with the ClientNameMap to get the ClientID column and lose the ClientName column. and then append all the client tables? 

 

Or should I append all the client tables and then merge the final table with the ClientNameMap table to get the ClientID column and then lose the ClientName column? 

 

The first involves more steps, but would it be processed faster since I more rapidly get to the ClientID (integer)?

1 REPLY 1
Community Support
Community Support

Re: What order should I merge and append queries in?

HI @Johnsnowlife,

 

>>Should I merge each initial table with the ClientNameMap to get the ClientID column and lose the ClientName column. and then append all the client tables? 

If these tables stored the similar structure records, you can merge them to one to help build relationships more easier.

 

I won't recommend you to merge all tables to append detail records to current table. These operations will generate huge amount of duplicate records.(may decrease the performance)

 

In my opinion, you can modify these tables and try to keep one entity one table.(e.g. customer table only store customer related info and the relationship column) Then use relationship column to build relationships link these tables.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors