Filter DataTable is not working with the simple = function

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.

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

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

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

1 Like