Merge 3 datatable

[Stef_99 (Stef)]

I have 3 datatable (sometime have 2 or 1 )

If I want to merge to 1 datatable.

please guide me for solve it.

Thank you

[lrtetala (Lakshman Reddy)]

Hi @Stef_99

Please check this

Merge more than two datable into one

Fine hope these steps would help you resolve ths –use a assign activity liket his arr_datatable = {datatablvariable1, datatablevariabl2,datatablevariable3} where arr_datatable is a varaible of type array of (system.data.datatable) where we can get this browse type –use a build datatable activity and create a datatable with same structure and get the output with a variabble named finaldt –now use a FOR EACH activity and pass the above variable as input and change type argument as system.d…

Regards,

[ppr (Peter Preuss)]

Have a look on the merge DataTable activity

For each Activity: item in {dt2,dt3}

• Merge DataTable activity , source: item, destination: dt1

Feel free to sahre with us sample data, when case differs from our assumptions

[Stef_99 (Stef)]

@lrtetala @ppr

–use a assign activity liket his
arr_datatable = {datatablvariable1, datatablevariabl2,datatablevariable3}
where arr_datatable is a varaible of type array of (system.data.datatable) where we can get this browse type

If first round I want assign arr_datatable = {datatablvariable1}
and round2 arr_datatable = arr_datatable + datatablvariable2

Please guide me for assign

Thank you.

[Kanak_Lata_Singh]

Hi @Stef_99

You can use Merge Datatable activity .

Please refer this ,

Activities - Merge Data Table

[ppr (Peter Preuss)]

@Stef_99

where we can get this browse type

select Array of[T]
Then select System.Data.DataTable