Compare 2 data and find the differences

Help Studio
, ,
1

The image shows a UiPath project with an open Expression Editor, where a column name in a DataTable is being reassigned from "ID" to "UserID". (Captioned by AI)
The image shows a UiPath project with an open Expression Editor, where a column name in a DataTable is being reassigned from "ID" to "UserID". (Captioned by AI)1900×798 80.8 KB

using the build data table activity, i have data inside which is show below
Data Table 1 (dt1):

ID Name Age
1 Alice 30
2 Bob 25
3 Charlie 35
4 Diana 40

Data Table 2 (dt2):

UserID FullName Age
2 Bob 25
3 Charlie 35
5 Eva 28
6 Frank 33

im trying to change the column name to be the same as the first data table but i have ecnounted an error, can yall show me how to do the steps from the start

2

Hi @Ryan_Lee

Try this way

aacaa
aacaa479×115 2.34 KB

In Save to: dt1.Columns(“ID”).ColumnName
and in value to save keep “UserID”
Hope this helps

3

@Ryan_Lee,

Follow this approach:

  1. Iterate through dt1 Columns using For Each activity. assign a index variable to it.

The image shows a "For Each" activity in UiPath that iterates through columns of a DataTable and assigns column names from one DataTable to another. (Captioned by AI)
The image shows a "For Each" activity in UiPath that iterates through columns of a DataTable and assigns column names from one DataTable to another. (Captioned by AI)1236×491 30.9 KB

  1. Add one Assign activity inside For Each like this
dt2.Columns(intColumnIndex).ColumnName = currentItem.ColumnName

That’s it. It will change the column names of the dt2 same as dt1

4

The image shows a UiPath workflow with an error indicating that 'DataTable.Columns' is being incorrectly used as a method in an assignment activity. (Captioned by AI)
The image shows a UiPath workflow with an error indicating that 'DataTable.Columns' is being incorrectly used as a method in an assignment activity. (Captioned by AI)1906×802 64.7 KB

how do i solve this error

5

@Ryan_Lee,

Argument type of the For Each might not be selected correctly. It should be like this.

The image shows an editor interface for looping over data table columns, highlighting the argument type set to "System.Data.DataColumn" within the "For Each" activity. (Captioned by AI)
The image shows an editor interface for looping over data table columns, highlighting the argument type set to "System.Data.DataColumn" within the "For Each" activity. (Captioned by AI)851×215 42.6 KB

6

The UiPath workflow image shows a sequence with validation errors related to the incorrect usage of the 'DataTable.Columns' member in an assignment activity. (Captioned by AI)
The UiPath workflow image shows a sequence with validation errors related to the incorrect usage of the 'DataTable.Columns' member in an assignment activity. (Captioned by AI)1407×766 51.8 KB

its correct tho

7

@Ryan_Lee,

You put the Save to as dt2.Columns(intColumnIndex).ColumnName right? Hover over it and show once.

8

The image shows an error in UiPath, indicating that the 'DataTable.Columns' member cannot be used like a method. (Captioned by AI)
The image shows an error in UiPath, indicating that the 'DataTable.Columns' member cannot be used like a method. (Captioned by AI)1450×748 64.3 KB

9

@Ryan_Lee,

Ok not sure what’s wrong but refer this code:

DtTestCode.zip (149.7 KB)

Output:
Red are before and Green one are after!

This image shows the DataColumnCollection for two different DataTables, with dt1 and dt2 columns being highlighted in red and green respectively. (Captioned by AI)
This image shows the DataColumnCollection for two different DataTables, with dt1 and dt2 columns being highlighted in red and green respectively. (Captioned by AI)722×413 31.2 KB

10

how do u find this output

11

@Ryan_Lee,

It’s from Immediate Panel. Learning resource here!

Kindly close the thread by marking my answer as solution so it will be helpful to other members as well.
Cheers!! :slight_smile: