Fetch particular data from excel sheet based on condition

I have following data in excel sheet.

data sheet:

loc sheet:

Take BatchID and Location from “loc” sheet filter “data” sheet on current Location
and fetch all Brand and Code data for that BatchID and Location.


Any help is appreciated :slight_smile:


We can achieve this using JoinDataTable activity as the following, for example.

Sample20230215-1L.zip (12.1 KB)