Add Collection<DataTable> to System.Data.DataTable

Help Studio
,
1

Hello there! I was wondering if there is anyone that can help me with this: I have a collection of type: Collection
and I am looking to have the data stored in it extracted and imported to a new DataTable of type System.Data.DataTable and then
manipulate the New DataTable created to set it to Clipboard.

2

What’s in the collection? What’s the full datatype? (mouse over it in the Variables pane)

3

@daryen.avendano

Welcome to the community

Can you explain what was the issue you are facing

4

Hi

Welcome to UiPath forum

If u have a set of datatable in a collection then u can combine them all together as one datatable provided if all the datatable has same format, same table structure and same order of columns

If they all are same as mentioned above then

  1. Use a Assign activity and mention like this
    dt_final = dt_collection(0).Clone

  2. Then use a Clear Datatable activity and pass the input as dt_final

  3. Now use a FOR EACH loop activity and you can pass that collection Variable to a FOR EACH loop activity where change the type argument property as Datatable in property panel

Inside the loop use a MERGE DATATABLE Activity where in source mention as item and in destination mention as dt_final

This dt_final will now have all the datatable merged together as one datatable

Cheers @daryen.avendano

1 Like
5

Hi, @postwick this is the full data type of the collection that’s storing the data

image

and this is the type of the DT i need to pass the values to

image

6

Hi @Shiva_Nikhil , im trying to extract data from a collection of type System.Collections.ObjectModel.Collection<System.Data.DataTable> and pass the values to a DataTable of type: System.Data.DataTable. i have tried using the Convert collection to Dt activity but is not extracting the actual values as i expected

7

@Palaniyappan Thank you for the help, however, it is not that im trying to merge collection and DT, I am looking to extract the values from the collection and pass it over to a new DT to manipulate it.

I have tried using the activity Convert Collection to DataTable but it is not extracting the actual values as i expected

8

When your collection already contains items (in your case DataTables) then you can access items e.g. by

First item
myDataTable | DataType: DataTable = YourCollectionVar(0)

3rd (as it is 0-based index)
myDataTable | DataType: DataTable = YourCollectionVar(2)

Last item
myDataTable | DataType: DataTable = YourCollectionVar.Last()

and we can retrieve how many items we do have by:
ourCollectionVar.Count

9

Then what you want to do is create a DT_Final datatable, then…

  • For Each in yourCollectionVar (set TypeArgument to System.Data.DataTable)
    ** Merge Data Table CurrentItem and DT_Final

So it’ll loop through all the datatables in the collection and merge them into DT_Final.

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.