Join 3 Datatable into 1

[Manii_K]

Hello Everyone,

I have 3 Datatable with same number of columns and same column name, I want to join all 3 into 1 how to do with linq, anyone pls suggest

[lrtetala (Lakshman Reddy)]

Hi @Manii_K

resultDataTable = (From row In DT1.AsEnumerable()
                                    Select row).Union(
                                   From row In DT2.AsEnumerable()
                                   Select row).Union(
                                   From row In DT3.AsEnumerable()
                                   Select row).CopyToDataTable()

Regards,

[lrtetala (Lakshman Reddy)]

@Manii_K

Another way

resultDataTable = (DT1.AsEnumerable().Concat(DT2.AsEnumerable()).Concat(DT3.AsEnumerable())).CopyToDataTable()

Regards,

[ppr (Peter Preuss)]

@Manii_K

I want to join all 3 into 1

is it about merging?
Assign Activity
dtMerged =

{dt1,dt2,dt3}.SelectMany(Function (x) x.AsEnumerable).CopyToDataTable

Or is it about Data Joins joining?

Story line of Join Data Table

Dear innovator’s, All we know that there is a Join Data table activity in UiPath.If we get any matching scenarios with unique value will approach join data table activity instead of filter/loop/array matching activity to find an exact match. Join Data Table: [image] Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the Join Type property. Sample Table: [image] INNER Join: The INNER JOIN keyword selects records that have m…

[ashokkarale]

@Manii_K,

Better to use Merge Datatable activity here. Give it a try.

Thanks,
Ashok

[postwick (Paul Ostwick)]

If they have the same columns, then it sounds like you want to do a merge, not a join. Use the Merge Data Table activity.

[Manii_K]

@lrtetala It’s working thanks