@datatable for each inside for each


#1

Hi Team,

I have one table contains one column after scraping as shown below: DT2
Price
23.4
676.4
355.34
32.2

Another table DT1 with required information, so I would require merge my Price column into it.
If I add DT2 column to DT1 it would be easier for me to consider my first value related to my first row of the DT1 table.
I need to iterate as number of times the values of DT2 and I need to iterate till my last price.
Could you please suggest my best way to do it.

Thanks
Girish


#2

Hi,

Try to invoke the following code using the invoke code activity, with input data tables.

Dim dc1 As DataColumn = DT2.Columns(“Price”)
DT1.Columns.Add(dc1.ColumnName, dc1.DataType)

For i As Integer = 0 To DT2.Rows.Count - 1
DT1.Rows(i)(“Price”) = table1.Rows(i)(“Price”)
Next