Merge Multiple Datatables

Help
, , ,
1

Hello,
I am struggling with an issue and hopefully someone can help me with here.

I have multiple datatables dt1, dt2, dt3, etc… they all have the same columns and headers. I want to merge all of them into one datatable dtX using maybe LINQ statement.

I ca do this with the merge activity but i’ll have to do it one by one. Is there a way to easily merge them together without having to use like 10 merge datatable activities? Thank you.

2

I haven’t played with merge data tables before but if you’re merging all 10 DTs into the same target, have you tried using a Collection to hold all the DTs and a for each construct to do the merge?

3

No i haven’t @pedro.arroyo how would that work

4

Hi @hatakora,
You would need to do the follwing:

  • Create a list of DataTable objects List<DataTable>
  • Add each dt to the collection (use Add to Collection activity)
  • Add a For Each activity (ForEach dt in dtList)
  • Add a Merge Data Table activity with this configuration:
    ** Destination: mergedDT
    ** Source: CType(dt,DataTable)

This will effectively merge all the data tables given that they all have the same schema.

5

Hi @hatakora

Use append range activity to append all datatable into single one

6

Make sense. I made an array and that seems to do it

7

Hi Nived,
How it is possible?
Any dummy workflow?

8

Check this Activities - Append Range

2 Likes
9

This thrown, “Object reference not set to an instance of an object” error.
Any idea, why i got this.

10

sorry. a silly mistake. Resolved :upside_down_face:

11

what was the solution i am facing same issue