VinayMurthy
Member
Within a loop, I want to use filter collection, for every iteration I need to change the filter criteria, please suggest how to achieve this
I have tried all the below combination but its not working :
Collection In [ExcelData]
Filter "Location = 'India'" : its working fine
Collection In [ExcelData]
Filter "Location = '[Data.Location]'" : not working (Data.Location is an another collection)
Collection In [ExcelData]
Filter "Location = [Data.Location]" : not working (Data.Location is an another collection)
I have tried all the below combination but its not working :
Collection In [ExcelData]
Filter "Location = 'India'" : its working fine
Collection In [ExcelData]
Filter "Location = '[Data.Location]'" : not working (Data.Location is an another collection)
Collection In [ExcelData]
Filter "Location = [Data.Location]" : not working (Data.Location is an another collection)