Scenario — We have 2 datatables available, 1 datatable contains regional data and other contains a list of Valid Regions.
Everytime the bot runs it should only consider the valid regions to pull data from Regional Sheet.
Here is the sample data
As you can see from the data, we only to retrieve data for ‘East’ and ‘West’ region from the first datatable. here is how you can do it
Write the Query in the Assign activity
Here is the complete video