I have 2 excel files, “Master” & “Export”
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?
How about using JoinDataTable and FilterDataTable as the following sample?
Sample20230711-1L.zip (14.5 KB)
Thanks, can you please share details about the join and filter activity?
I couldn’t check details within the script you provided.
Hope the following helps you.
Join DataTable (please set Left at JoinType)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.