I’ve been creating an automation where in im going to merge two excels by the use of assigning a primary key to a column. It works fine. But when I run the automation, it also appends the data from the second excel even though there is no primary key on the initial excel. Help!
Let me explain you briefly in what can be done for this
—we can use MERGE DATATABLE ACTIVITY where mention the two datatables as input
—make sure that those two datatables have same number of columns, same order of columns, same datatype of columns
—if any of these conditions fail it won’t merge and we will getting error merging them
If we want to join those two datatables based on a condition then we can use JOIN DATATABLE activity
For more details on it