Compare excel column with a value

hi Experts,
i have a table that contains 10 records. i need to filter column B if the value is greater than 10. can you teach me how to do it. thank you.

Hi @MJ_Pulao

Use Filter Data Table Activity and use this condition ColumnB>10 create output data table variable use write range activity there you can pass data table you will get the result.


Kommi Jeevan.


Check this workflow, @MJ_Pulao
Forum_Test_3.xaml (5.3 KB)
and input file Sample_Test.xlsx (7.4 KB)

1 Like

thank you, got it…

am sorry @kommijeevan my data stored in the excel file is of string type.
so when i try to filter, it doesnt work.
am trying to filter a column “Mobile Number” but this data when i use read range it is of string value.
i think for the Filter Data Table to Work, i need to convert the column to Int32 first?
but am not so sure how to do that. been searching but am not able to get it.
thank you for helping

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.