Copy DataTable to another DataTable

Help
1

Hi I have an array of DataTable and I would like to exact copy my DataTable created into the array. Is it possible?

2

If you want to copy a datatable:

myNewDT = DT.Copy()

If you want to create a datatable from an array of datarows:

myNewDT = myArray.CopyToDataTable()

5 Likes
3

Assigning a variable with type System.Data.DataRow() (a datarow array) to DtData.Select will create an array of rows from datatable DtData.

4

Tried the DT.Copy() it throws this error instead

image
image797ร—343 19.5 KB

5

Could you please try before your assignment:

Assign (DataTable)
dtTemp = dtLineItem.Copy()

?

1 Like
6

Seems like there is an issue when assigning datatable to an array of datatable. When I tried to assign to a single datatable itโ€™s fine

7

And

Log Message
dtArray.Length.ToString

?

8

This error appears when I tried to assign a dt to an array of dt

image
image872ร—436 19.5 KB

9

the message states that your index is beyond the array limit. Are your trying to build an array or to update an already existing member of the array?

10

Iโ€™m trying to build an array. I declared the array as variables and later on I assigned it with my datatable

11

You could build a List with default as New List(Of DataTable), add your datatables to the list then convert it later to an Array if necessary.

Iโ€™m convinced the problem is with your arrayโ€™s initialisation.

EDIT: Iโ€™m discovering VB with UiPath and just find out about DataSet: might be a better structure. Iโ€™ll dig into it tonight.

2 Likes
12

Alright thank you so much for your help @msan

13

@Seungwan

Hello,

While DataSet is very neat, it might not suit your approach.

If you know the number of item your array will have, you might do:

Assign (Int32)
intArrayLength = ?

Assign (Array Of DataTable)
dtArray = New DataTable(intArrayLength){}

Your array will be ready for your loop.

If you donโ€™t know how many items youโ€™ll have, create first a list, add each item in your loop then if necessary convert the list to an array:

Assign (List Of DataTable)
dtList = New List(Of DataTable)

Loop

  • (whatever you need)โ€ฆ

  • AddToCollection
    Type of argument: DataTable
    Collection: dtList
    Item: dtLineItem.Copy()

  • (whatever you need)โ€ฆ

// If needed
Assign (Array Of DataTable)
dtArray = dtList.ToArray

1 Like
14

Hi @Seungwan !

To make an exact copy of a DataTable into an array of DataTable in UiPath, you can use the following steps:

  1. Declare an array of DataTable with the desired size:

    • Use the Assign activity to create an array variable of DataTable type with the desired size. For example:
    ArrayVar = New DataTable[ArraySize]

  2. Copy the DataTable into the array:

    • Use the Assign activity to copy the DataTable into the array at the desired index. For example, if you want to copy SourceDataTable into index 0 of the array:
    ArrayVar(0) = SourceDataTable.Clone()
ArrayVar(0).Merge(SourceDataTable)

  3. Repeat the above steps for each DataTable you want to copy into the array, adjusting the index accordingly.

By following these steps, you can create an exact copy of a DataTable and store it in an array of DataTable in UiPath.