Excel structure data filter

[Ravi_Shirsath]

I am having below type of structure of Excel files i need to filter date should be 2019 position should be sales,. And email should not blank, payment mode credit card how i can achieve this ,sample files

[lukas.gamper]

Hello @Ravi_Shirsath,

you have multiple Excel files you want to check?

What do you mean you want to filter? Should the files which meet your criteria be moved someplace else?

Kind Regards

[Ravi_Shirsath]

Yes if matches i am extractiong name of company ,price and lot of thing into New excel

[Anil_G (Anil Gorthi)]

@Ravi_Shirsath

Lopp through each file

Read the data into datatable…

And then use lookup datatable and get the required values

For example if you need Date then use lookup and find date which would give yout the next cell value as needed…

Then you have all the values…use if condition to check the required conditions and do your process in then block and leave else blank

Cheers

[Ravi_Shirsath]

Any xaml solutions if you can provide that would help

[Anil_G (Anil Gorthi)]

@Ravi_Shirsath

Can you please provide the input file here

Cheers

[Ravi_Shirsath]

application.zip (97.7 KB)

This all the input and output files

[Ravi_Shirsath]

This is all given