Filter Data Table error issue & solution suggestion?

Help Studio
, ,
1

Hi all,

I’m following the online course and it’s currently teaching excel related materials specifically on filter tables.
Left screen: from the course
Right screen: my studio

I have followed all the steps and I’m getting a Filter Data table:Data Table error which in my limited knowledge isn’t helping me understand where the problem is.

I’m quite confused and if anyone has any idea what the problem is and the solution would appreciate it!

ss1: filter rows

image
image3146×834 344 KB

ss2: output columns

image
image2848×894 354 KB

ss3: activities before the above

image
image1536×610 45.1 KB

Edit ss4: the raw data
image

2

Hi @Dillon_Marius ,

Could it be the case that when you were configuring the Filter Datatable activity, you were pasting the copied values into it ?

If so, could you give a try by re-typing the values into the Filter Datatable ? Do not copy Paste the values.

3

Hi Superman,

Thanks for the input.
I did just that and in fact made a whole new filter data table wherein I typed the value in (not copy pasting).

However it still says the error Filter Data Table Faulted
image

4

HI @Dillon_Marius

can you try with this xaml hope it will help for you

xaml :- Filter Data Table error issue.zip (1.7 KB)

for your reference input and out

input : - image

output:- image

the out filtered on the above which as less then 2005…

5

You’re reading from Excel so the Revenue column is probably string not integer. You’d have to convert it to integer before you can use Filter Data Table to look at the amount.