Two DT (how to filter and add rows)

Help Studio
1

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)

2

Hi,

Hope the following helps you.

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

img20201125-1
img20201125-1605×563 14.9 KB

Sample20201125-1.zip (9.0 KB)

Regards,

2 Likes
3

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.

4

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