How to use filter data table activity after a read range activity


#1

Hi, I am doing Lesson 9 Practice 2 from the Foundation Training - revamped course. I need to read an excel sheet and then filter the obtained data table using a Filter Data Table Activity by a column “ID” of type Int32. But when I use the activity and set filtering criteria:
Filter%20wizard
I got an error because it says that the column is of type Object and in order to make the comparison, it needs to be of type Double. There is any way for me to define the type of the columns of the data table I obtain from the Read Range Activity, or to cast the type of data at the moment of the comparison?
I want to do it by the Filter Data Table Activity. I know that there are others workaround, but the purpose of this exercise is to use this activity. Thanks in advance.


#2

Hey did you find any solution for this, I am stuck with same error.


#3

Hey,

you should use a decimal value while filtering. Instead of 10 write 10.00. It should work then, at least worked in my case.


#4

Whenever I need to compare to the number, use double instead of int. My filtered data table always worked with double not int.


#5

Exceldata.zip (13.9 KB)
@Vivian You can refer the below xaml file


#6

@Babla, that worked out, thanks. Sorry for the very late reply.


#7