Combined data tables with no reference column

[wth1993]

Hello there. I have three data tables. I want to combined them to a new datatable for my further handling. I tried Join & Merger datatable function but they didn’t work because there’s no common column for matching.

Thank you for your help. I have attached the picture for your reference.

[ppr (Peter Preuss)]

Removed: Approach was changed

[wth1993]

Having checked the output table the user wanted, I don’t think it is what I want…
Please note that in my desired output, there are only four rows.

[ppr (Peter Preuss)]

Removed: Approach was changed

[wth1993]

HI ppr, I was trying this but encountered some difficulties. Firstly, your example is only for two data tables. Does it mean I should first do it with dt1 & dt2 for a desiredDT, then do it with desiredDT & dt3 for new desired DT?

Moreover, it’s showing the error when I used the invoke method activity.

[ppr (Peter Preuss)]

Removed: Approach was changed

[wth1993]

Ok, I tried it with dt1 and dt2. The output is indeed a lot more than 4 rows. Just like what I mentioned earlier. I don’t need 4 rows of each name. Could you please advise?

[ppr (Peter Preuss)]

Removed: Approach was changed

[wth1993]

Hi Peter, could you see the photo already attached in the first post? It showed the 3 data tables on top and the desired output I want below on the same photo.

Please let me know if you couldn’t see it. Thank you.

[ppr (Peter Preuss)]

Removed: Approach was changed

[wth1993]

Yes, as showed in the photo, only four rows in DT1, excluding the header.

Name Age Nature
Funny 25 Combine
Studio 26 Other
Question 36 Fine
Data 13 Thank

Could you please share the xaml file on how you do it?

[ppr (Peter Preuss)]

i guess I got it. Let’s shift to another approach. Give us please some time for this.

Could look like this:

• merge the structures dt1,dt2,dt3 - targetDT
• (assumed all tables will have the same rowcount
• iterate over first dt1, use loop index to pick up the rows from the other tables
• add combined RowArray to the targetDT

[wth1993]

Hi Peter, thank you in advance! Yes, all data tables will have the same row count

[ppr (Peter Preuss)]

@wth1993
With the constraint that all datatables have the same row count here we go:
Variables:

Preparing dtResult by Merging all DataColumn Structures:

Doing the Merge / Combination

Result:

As an alternate it can be done with a LINQ:
Merging we do the same way as above (dtResult was cloned therefore)

Find starter Help here:
MergeDataTables_SideBySide.xaml (17.2 KB)

[wth1993]

Thank you very much, Peter! It works perfectly!