Fetch particular data from excel sheet based on condition

Help Forum
, , , , ,
1

I have following data in excel sheet.

data sheet:

1
1707×821 57.3 KB

loc sheet:

1.2
1.2378×817 29 KB

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.

Output:

2
2727×815 64 KB

Any help is appreciated :slight_smile:

2

HI,

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

image
image718×1763 44.7 KB

Sample20230215-1L.zip (12.1 KB)

Regards,