I am trying to use VB .net methods to filter a datatable instead of using filter datatable or other available finished activities (supposed to be awarding negative points). In this I am using values stored in the config file to control which columns I need to extract. It works fine with remove data column (could also use add datacolumn when assinging to another table, but I figure that I can just use the table that the scraper provides me with).
So my problem is that when I try to just use eg. datatable.select method I can’t make it work. I have tried other approaches such as iterating through rows and table.columns, but I cant make it work.
In detail - I try to assign three columns out of five extracted columns, and for each row in that table to the other table. I have managed to do it dynamically using available activities and using a config file but I want to use VB .net code instead.
Appreciate any help provided.