Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
Proud to be a Super User!
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.
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
Proud to be a Super User!
Hi,
Use the Append feature of the Query Editor.
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
Proud to be a Super User!
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |