Specific price range search from excel sheet

Hello everybody! :slight_smile:

I would like to filter the results from a csv file according to price range, and then get the related information in the row (name, rating) and show the new results in a csv file.

There are 3 columns of data in the csv (name, rating, price)

This is what the csv looks like:

also my filter criteria comes from a multiple choice input dialog box where the user has picked a price range (e.g. 50-100 dollars)



Hi @RobbieJ

Use the filter condition with and condition

Like the price >50


price <100

Thank you for the quick reply @NIVED_NAMBIAR, but the issue remains that it is a different value every time, as the user chooses the price range at the beginning of the process.

Also it needs to gather the correlating data (hotel, rating, price)

So i would need to filter with a variable.

the options are as follows: