DT Remove Row on Condition (Filter Wizard)

Hi Guys,

Not understanding what should be a simple operation.
The filter wizard works great on text but on integers im stuck.
Read range from Excel ( col A / index 0 ), into a DT.
Values in Excel are formatted as whole number.
Trying to remove values >200.
As per output, no go.
Furthermore when I change the operator to contains and surround the value with quotes, ie “200” it removes the 200 from the dt, so im guessing the read range is stored in the dt as text ?


Screenshot 2022-09-25 124343

Screenshot 2022-09-25 124312

Screenshot 2022-09-25 124402

Right, it appears I have to write this range to a built dt specifying the column as integer.
Will report back…

Hi @MikeC
When you are storing values through read range it is storing all the values as a string.
And when you are using build datable you are defining each column type.

1 Like

Hey buddy,

Yeah figured it out, cant do math on strings :joy:
Got it sorted now, filters any value above 200.
Quick one, whats the code if I was using the datarow instead of the arrayrow ?
Thank you.

Screenshot 2022-09-25 175055

Screenshot 2022-09-25 175344

Hi @MikeC ,

Check the below post for using the DataRow Property of the Add Data Row Activity.

1 Like

Ahhhhh DataRow property, got it :ok_hand:
Must admit the arrow row is somewhat easier, thank you :grinning:

1 Like

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