Let’s say we have two data table
Table 1 contains All the data including duplicates under the column ORDER NUMBER
But Table two contains only unique data’s under the column ORDER NUMBER
Now Question is
From Table 2 whatever unique data’s is available under the column ORDER NUMBER for that unique data’s I need get the relevant duplicate data’s aswell from Table 1.
I mean need to get the duplicate rows along with the original row
How to do it Any idea
This is a good use case for the Select Method, you may need to extract the unique identifiers of your Table 2. and lookup the first table based on them. You may get a similar result using the filter datatable activity.
In the end the logic is the same: define the search criteria, and then lookup the data you need
Join Data Table will be a good option to go with !