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
CaptureQWEQWE
Book2.xlsx (9.0 KB)

Hi,

Hope the following helps you.

First filter datatable B, then merge B to A using Merge DataTable activity.

Sample20201125-1.zip (9.0 KB)

Regards,

2 Likes

In this video, I have demonstrated a similar scenario Adding Specific Columns From One Data Table To Other - YouTube

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.