How to filter a scraped table (from website) with integer values

Hi Guys :wave:

I’m currently stuck with the problem that i want to filter a scrapped Data Table. The Data Table contains strings and integers. I want e.g. to filter the table according:


row(“Type”).Equals(“WI5”) AND row(“Status”).Equals(“Open”) AND values from Column WIID < 500000

Filtering the strings works perfectly fine, but when it comes to WIID (i believe the values are integers?) it doesn’t work. I tried filtering with the Filter Data Table Activity too, but it doesn’t work either.

Thanks for your help! :smiley:

1 Like

Try with select method like this
yourdatatable = yourdatatable.Select("Convert([WIID],system.int32)< 50000 AND [Status] = ‘Open’ AND [Type] = ‘WI5’ ").Copytodatatable()

Cheers @Mod0091

1 Like

wow, thanks buddy @Palaniyappan It works like a charm! :clap: The funny thing is that i even tried that solution yesterday too but it didn’t work and now its working :smiley:

Cheers

1 Like

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