query help

[sanjay009]

i have to tables

table 1 

A1 A2 A3

4   4   6

3   5   6

table 2

type

A1

A2

i want to remove column A3 from table which doesn;t match in table 2.

please advise.

[amitchandak]

@sanjay009 , Unpivot the first table, Join to and use it.

https://radacad.com/pivot-and-unpivot-with-power-bi

https://youtu.be/2HjkBtxSM0g

Append -Merge -https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

[Greg_Deckler · Accepted solution]

@sanjay009 - Maybe unpivot your columns in Table1. Then you could do a Right-Anti Merge (if not then Left Anti) I believe to squash your A3, then you could pivot back if you need to. This would be in Power Query. You could do a Merge New or Merge step on your Table1.