Combine 2 Y or N columns in different tables so that I can make 1 pie chart

[Anonymous]

Hi,

I want to combine a N or Y column in a table called AIP, with a N or Y column in a table called OIP to make 1 pie chart that shows N or Y overall

[Anonymous]

Hey Guys,

Thanks for the reply.  I just duplicated both tables deleted all other columns and left the N,Y columns,  then appended to a new table.  I was hoping to find a code to just create a table that would append the column without having to duplicate and then append.

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

= Table.Combine({AIP, OIP})

In Power Query, the above is the code to append two or more tables.

I started with two dissimiliar tables, combined the two and created a new table. I used the Power Query Append Queries as New.

Power Query used null for the data in unshared columns.

Then you could delete any columns you don't need by selecting the columns you do need, and Delete Columns Other. 

Probably easier and quicker. No duplication required.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

    

 

[Ashish_Mathur]

Hi,

Use the Append feature of the Query Editor.

[Nathaniel_C]

Hi @Anonymous ,

So what would the logic be? If 2 Ys then Y, and if two Ns then N? What about the other two cases Y/N, N/Y?

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel