Writing data table values to a new data table?

[dr1992]

Hey there,

I have a DataTable of scraped items from a portal, however, there are some which will not be required. I therefore want to write the required items to a new Data Table so I can filter out the ones I don’t need.

How would I go about writing these to a new table? I tried a ‘for each row’ with an ‘if’ activity to select the items I wanted, however, it tells me that it cannot write to a new DT if iterating through another.

Any help would be appreciated, thank you!

[arjunshenoy]

Hi @dr1992

You can try ‘Filter data table’ activity & provide the conditions based on which you can obtain the desired result. Also, you can use LinQ query to achieve the same.

Cheers

[dr1992]

Unfortunately, filtering will not be an option based on some specific needs I have of this build (it is quite complicated to explain aha)

[arjunshenoy]

You can make use of LinQ queries in that case. You can directly use both Assign activity or Invoke Code activity to implement the LinQ.

[Aakash_Singh_Rawat]

Hi @dr1992,

If you want to get less no. of columns only and of course specifc rows then you can Build A new DT with those columns name and inside your for each row for a condition; use Add data Row.

In ArrayRow property put {CurrentRow(0).ToString, CurrentRow(1).ToString…} so on.
These no. of elements inside { } should be equal to your New DT’s column count, and you can use different Index to take columns value from original DT.

Let me know if it helps.

[dr1992]

Hey,

Am I doing something wrong with the filter wizard here? I essentially need to remove the row (of column 0) if the value is a set variable or the bottom text. I ran it, it doesn’t error, but it also doesn’t remove it.

Any ideas?