DT Remove Row on Condition (Filter Wizard)

[MikeC (Mike)]

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 ?

Thanks

[MikeC (Mike)]

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

[raja.arslankhan (Raja Muhammad Arslan khan)]

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.

[MikeC (Mike)]

Hey buddy,

Yeah figured it out, cant do math on strings
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.

[supermanPunch (Arpan)]

@MikeC

Quick one, whats the code if I was using the datarow instead of the arrayrow ?

Hi @MikeC ,

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

How to use Add Data Row activity?

[image] declare new DataRow variable e.g. “newRow” initialize “newRow” to be a new row of your datatable by assining dt.NewRow to “newRow” variable assign values to newRow variable e.g. newRow(“Name”) = “test” after all the values are assigned, use “Add Data Row” activity, fill in dataRow and dataTable properties. (Note - you can use ArrayRow property by passing in newRow.ItemArray)

[MikeC (Mike)]

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