How to add three data tables into one data table

[Kavya_Mamidishetti2 (Kavya)]

I have 3 Data tables DT1 with the “Item” column
DT2 with the “Property” column
DT3 with the “Info” column
I want to add/append all these columns into a single data table. Say FinalDT.
Need to use only 1 “Write Range” activity.Merge is not working.
Any suggestion is appreciated.

+ +

The excel should be in the below form

[ppr (Peter)]

side by side merge

• done by combining the datatables within a datable (Classical, LINQ…)
• repeated write range with offset A1,B1,C1 for the different datatables

We are doing it in this way as e.g. in contrast merge datatable will not do a side by side merge

[lakshman (Ganta lakshman)]

@Kavya_Mamidishetti2

Use 3 Write Range activities and pass DT1, DT2 and DT3 respectively to it.

Mention Range as “A1”, “B1” and “C1”.

[postwick (Paul)]

Merge Data Table

[Kavya_Mamidishetti2 (Kavya)]

@lakshman Thanks for the suggestion. Now I’m following the same process where 3 “Write Range” activities write into same excel. This reducing the performance(Opening and closing excel so many times).
That’s why i want to add columns into single data table and write into excel.

[Kavya_Mamidishetti2 (Kavya)]

@ppr please look into this How to add three data tables into one data table - #5 by Kavya_Mamidishetti2

Using Merge the output is something like

[Kavya_Mamidishetti2 (Kavya)]

@postwick Thanks for the response. Merge didn’t work.

[ppr (Peter)]

@Kavya_Mamidishetti2
Create an empty datatble with the three cols with the help of Build datatable - dtMerged

then use an assign activity:
left: dtMerged
right

(From x in Enumerable.Range(0, dt1.Rows.Count)
Let ra = new Object(){dt1.Rows(x)(0),dt2.Rows(x)(0),dt3.Rows(x)(0)}
Select dtMerged.Rows.Add(ra)).CopyToDataTAble

Feel free to use ColName instead of ColIndex

in case ofg the datatables will have different row counts we can adopt also have a look here:

Merge Data Table , Join Data Table query

Sounds like a side by side merge Have a look here: Another option is to write out the different DataTables to the same sheet just by ofssetung the range to right for each datatable

[postwick (Paul)]

Why didn’t it work? It should. It’s what it’s for.

[Kavya_Mamidishetti2 (Kavya)]

Hey @ppr Thanks a ton. That’s working amazingly. Thanks for quick response too.

[Kavya_Mamidishetti2 (Kavya)]

yes, but it is writing data in the below format. However, solved the problem.