Append table in Query Editor but only bring in matching rows

[Anonymous]

Hi there

I have two tables and I want to append table 2 to table 1. I actually only have one column that I care about.

Currently when append table 2 to table 1, it brings in all columns from table 2 and I then delete all but one. To avoid this step, I would just like to append the one column I need from table 2 into table 1, which has a column of the same name.

Is this possible?

[negi007]

@Anonymous You can remove column you dont need your final appended data. You can do it before appending or after appending tables. You have to use the option append queries instead of merge queries

[AlB]

Hi @Anonymous 

Can you show the two original tables and the expected result?

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[amitchandak]

@Anonymous ,

In power query , when you merge you can choose the column

Refer my video : https://youtu.be/zNrmbagO0Oo

Check merge - https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Or in dax you can bring column value, refer my video : https://youtu.be/czNHt7UXIe8

[Anonymous]

@amitchandak Sure, you can select columns when merging. But i'm interested in appending.

[aj1973]

Hi @Anonymous 

Yes it is possible, in Power query choose the column you need to see in your model. An Applied step will appear in query settings and it will take care of it on refresh.