Forum Discussion
Copy data to other columns
Hello everyone, I have a question, please help me with this. How can I copy the data in Table2. to corresponding column like the screenshot belowing. Thank you
bolfri
Solution Sage
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.