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.
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.
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.