Compare excel column with a value

Learn
1

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.

2

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.

image

Regards,
Kommi Jeevan.

2 Likes
3

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

1 Like
4

thank you, got it…
appreciate…

5

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

6

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