Another reason why Filter datatable activity in my logic always return zero

Help Studio
1

Hi
i am checking whether variable1 is in the data table or not by using filter data activity .
Actually it is exist. but the message box checking for the filtered dt always return zero.
Then i changed the condition “No” not equal to variable , then it return all rows.
variable1 is string type.
Thanks

スクリーンショット (341)
スクリーンショット (341)761×384 13.9 KB
スクリーンショット (340)
スクリーンショット (340)790×530 21.5 KB

2

Hi,

Can you share your workflow and data as file, if possible?

Regards,

3

Hello @Yoichi
here it is. Thanks ahead

BSPL.xlsx (9.3 KB) Main.xaml (10.2 KB)

4

Hi @eimon

I think it should be a number type in excel please use convert.toint32(variable1.tostring.trim) in filter datatable

Or

cint(variable1.tostring.trim)

Or give variable1 datatype as integer in UiPath and just past the value in the filter datatable

2 Likes
5

Thank you for your help @prasath_S

6

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