@datatable for each inside for each

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

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