Two DT (how to filter and add rows)

Hi All,

I have two DT’s A and B
I have to compare them. And add to table A rows from table B if value from column ‘Number’ is no already in table A

Book2.xlsx (9.0 KB)


Hope the following helps you.

First filter datatable B, then merge B to A using Merge DataTable activity. (9.0 KB)



In this video, I have demonstrated a similar scenario

Mark it as a solution if it helps.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.