Hi to all,
I need to scrape a table, and then filter the columns.
Of these, I need to cut a partial string, but it doesn’t seem to work, with the FILTER DATA TABLE activity.
These are the two columns.
Service/Time Sheets #69742
So, how did I setup the activities:
but using this setting, the first two columns disappear in table B.
…and I also need to know if there is also a way to do logic on another cell.
Column 14 contains a string plus, optionally a text field, always “none”, or a date.
I wish it could understand if after the string “Actual Completion” there is a date, then it collects the date, otherwise the string “none”.
Is it possible to always do this in the Filter Data Table activity?
Is there a way to do it all in one step?
Thanks A lot…
In filter datatable columns tab is used to remove or retain columns but not to modify the data of the column
If you need to filter rows then use rows tab
If you need to so any manipulatiosn on data then either use For each row in datatable and perform manipulations inside or use Expressions Eg: dt.Columns("ColumnName").Expression = "SUBSTRING([ColumnName], 1, 5)"