Filter DataTable is not working with the simple = function

Help
,
1

Simple equal(=) function is not working in Filter Datatable activity. I have took the dt with data and filtered using Filter Datatable activity and returns empty rows.

image
image806Ă—571 13.9 KB

2

The root cause is data type of GL Account.
This column is text type, but its value is number tyep, so the result of Filter is not correct.

1 Like
3

But am getting the account type directly from excel, how to change the datatype ?

4

It’s not simple.
You can use below expression
Assign dt_finalSRC = dt_finalSRC .AsEnumerable().Where(Function(x) CStr(x(“GL Account”)).Equals(“23900306”)).CopyToDataTable

2 Likes