How to filter a datatable by another datatable column value?

Help Studio
, ,
1

I have 2 excel files, “Master” & “Export”

“Master” Excel
image

“Export” Excel
image

I wanted to generate a new Excel called “New”, expected result as below
image

How to filter “Export” excel with “Master” excel column “ID”? Or any other way to achieve this result?

2

Hi,

How about using JoinDataTable and FilterDataTable as the following sample?

image
image902×890 42.3 KB

Sample20230711-1L.zip (14.5 KB)

Regards,

3

Hi @Yoichi

Thanks, can you please share details about the join and filter activity? :pray:
I couldn’t check details within the script you provided.
image

4

HI,

Hope the following helps you.

Join DataTable (please set Left at JoinType)

image

Filter DataTable

image

image

Regards,