cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gujames Frequent Visitor
Frequent Visitor

Append Tables Issue in Power BI

I'm having an issue when tryingto appending two tables together w/ a single reference category (In the below, the category is col1 -brand). I'd like for the resulting table to have only 1 col for all Lats, and 1 col for all Longs,  but it creates a new column for each of the seperate tab columns except the Brand column..

 

Any help with my issue below would be extremely helpful!

 

Data is broken out per the below:

Table 1: Brand Index

Col1 - Brand

Col2 - Index

Col3 - Latitude

Col4 - Longitude

 

Table 2: Brand Locations

Col1 - Brand

Col2 - Latitude

Col3 - Longitude

 

I'd like to merge the datasets so that the result shows:

Col1- Brand

Col2- Type (Index vs Location)

Col3- Index

Col4- Latitude

Col5- Longitude

 

But when I try to merge the datasets, or append them, I end up with two columns for Latitude and 2 columsn for Longitude. Any advise here would be greatly appreciated.

1 REPLY 1
Super User
Super User

Re: Append Tables Issue in Power BI

Hi @gujames,

When appending queries the columns names need to be the same in both tables otherwise the append will create a column for each different name.

Be aware that if you have a space or a cap differende in the names of the columns the query editor will consider it a different column..

Regards
MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!