Forum Discussion
Copy data to other columns
I think is what you did is merge queries and you suppose to use append queries.
Refference: https://www.youtube.com/watch?v=oUB11A855g8
Hi bolfri
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.
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.
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.
All the data fields are same for both table.
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.
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.