I want to add 2nd sheet data for each row of 1st sheet data, cross join

Help Activities
, , , , , , ,
4

Hi @Nidhi_Gupta1

Step1 ~ read range, both sheets
You will get 2 data tables dtSheet1 and dtSheet2

Step2~build data table (this is where u will get output , add all columns from sheet1 and then sheet2

Step3~use assign activity

dtResult = (From row1 In dtSheet1.AsEnumerable
From row2 In dtSheet2.AsEnumerable
Select dtResult.LoadDataRow(New Object() {
row1(“IN1_Name”), row1(“IN1_Age”), row1(“”),
row2(“IN2_Name”), row2(“IN2-Age”), row2(“”)
}, False)).CopyToDataTable

Please make sure to add all columns above I wrote 2 for each sheet for reference

Step4~ write range dtresult

Let me know if it works .

Thank you !

1 Like