Updating other columns in datatable

[tharani.natarajan]

I have a Master DataTable with columns: Name, URL, Site Address, EmailID. I also have an API DataTable with columns: URL, Address, Name, EmailID. I need to check if each URL from the API DataTable is present in the Master DataTable. If the URL is found in the Master DataTable, I need to update the corresponding row’s columns with values from the API DataTable. If the URL is not found in the Master DataTable, I need to append a new row to the Master DataTable with all the details from the API DataTable.

Can you please help me with updating the rows in the Master DataTable if the URL is present?

[ppr (Peter Preuss)]

Have a look at the Join DataTable Activity and model some postprocessing of the JoinResult

Story line of Join Data Table

Dear innovator’s, All we know that there is a Join Data table activity in UiPath.If we get any matching scenarios with unique value will approach join data table activity instead of filter/loop/array matching activity to find an exact match. Join Data Table: [image] Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the Join Type property. Sample Table: [image] INNER Join: The INNER JOIN keyword selects records that have m…

When providing sample data we can also check and rate alternates