Forum Discussion
Copy data to other columns
Solution SageCan 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.
- bolfri
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.