Copy data to other columns

Question

Hello everyone,I have a question, please help me with this.&nbsp;How can I copy the data in Table2. to corresponding column like the screenshot belowing.&nbsp;Thank you

bolfri · Answer

I think is what you did is merge queries and you suppose to use append queries.Refference:&nbsp;https://www.youtube.com/watch?v=oUB11A855g8&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;bolfri&nbsp;Thanks for replying me.I do need to merge queries, buecause I need to follow some logics to remove or add data so I choose to merge them. I need to know which table it's coming from.

bolfri · Answer

Can you provide some sample data to work with and the logic you want to apply?

On your example you have same columns and business meaning that's why I said it would be better to append them. Even with appending data you can save an information about the source table name.

anonymous · Answer

The logics are simple. Only 2 rules.1. if name shows in table1 but not table 2 then remove it from table 1.2. if name shows in table 2 but not in table 1 then add it into table 1.&nbsp;&nbsp;All the data fields are same for both table.&nbsp;My idea is merge them together and expand the table. Adda new column to check I want to remove or add or keep. So I got the table you saw.

bolfri · Answer

In this case it's still better to do the append with filltering out the records from table 1/2 (putting your logic) than creating custom column that combines them together. It's more manual work. To avoid manual work you can use Power Query M to do that for you.

Forum Discussion

Copy data to other columns

5 Replies

Related content

Copy Job - Column Mapping

Copy Job vs Copy Activity

Copy paths

Copy table / Copy Column doesn't work

Copy Job OVERWRITE