How to filter a datatable by another datatable column value?

[mlellison (Max Ellison)]

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

“Master” Excel

“Export” Excel

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

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

[Yoichi]

Hi,

How about using JoinDataTable and FilterDataTable as the following sample?

Sample20230711-1L.zip (14.5 KB)

Regards,

[mlellison (Max Ellison)]

Hi @Yoichi

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

[Yoichi]

HI,

Hope the following helps you.

Join DataTable (please set Left at JoinType)

Filter DataTable

Regards,