How i can combine and mutilpy rows from 2 data tables

Help Studio
,
1

How can i mutiply data table 1 to each row in data table 2 ?

image
image907×262 18.2 KB

3

Hi @Rpa_compara ,

Is this the output you were expecting?
image
image

If so, then here is the code used to achieve it, along with a sample workflow for your reference:

(From r2 In dt_2.AsEnumerable()
	From i In Enumerable.Range(0,dt_1.Rows.Count())
		Let ra = dt_1.Rows(i).ItemArray.Concat(r2.ItemArray).ToArray()
		Select dt_result.Rows.Add(ra)).CopyToDataTable()

AccumulateDataByMerging.xaml (11.4 KB)

Kind Regards,
Ashwin A.K

1 Like
4

ir worked great. thanks @ashwin.ashok

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.