How i can combine and mutilpy rows from 2 data tables

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

Hi @Rpa_compara ,

Is this the output you were expecting?

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

ir worked great. thanks @ashwin.ashok

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