Comparing column name between 2 excel

Help Studio
, ,
1

Hi Guys,

i need to compare between column name in 2 excel and copy all row in that column name.
how do i do it?

2

Hi @zaffan.isa

Can you share the sample Input and expected output.

Regards

3

Sure

A spreadsheet displays three columns labeled ID, Name, and Age, with corresponding values of 1, 2, and 3 for ID; John, Lemon, and Same for Name; and 34, 35, and 36 for Age. (Captioned by AI)
Sample Input

image
Expected Output

Both are different excel file and they have different format of data table

4

Hi @zaffan.isa

Can you please share 2nd excel file

Regards,

5

This is the second excel.

image

6

@zaffan.isa

Can you try below query

FinalDT = DT1.DefaultView.ToTable(False, DT1.Columns.Cast(Of DataColumn)() _
    .Where(Function(col) DT2.Columns.Contains(col.ColumnName)) _
    .Select(Function(col) col.ColumnName).ToArray())

Regards,

7

@zaffan.isa

Another approach

The image depicts a sequence of activities in UiPath's automation workflow, including reading two sheets from "Excel1.xlsx," processing code to clone and manipulate data, and writing the final result to a new sheet in the same workbook. (Captioned by AI)
The image depicts a sequence of activities in UiPath's automation workflow, including reading two sheets from "Excel1.xlsx," processing code to clone and manipulate data, and writing the final result to a new sheet in the same workbook. (Captioned by AI)818×700 37.7 KB

Invoke Code:

resultDT = DT2.Clone()

For Each row As DataRow In DT1.Rows
    Dim newRow As DataRow = resultDT.NewRow()
    For Each col As DataColumn In resultDT.Columns
        If DT1.Columns.Contains(col.ColumnName) Then
            newRow(col.ColumnName) = row(col.ColumnName)
        End If
    Next
    resultDT.Rows.Add(newRow)
Next

The image displays a dialog box titled "Invoked code arguments" that lists three data table arguments with names, directions, types, and corresponding values. (Captioned by AI)
The image displays a dialog box titled "Invoked code arguments" that lists three data table arguments with names, directions, types, and corresponding values. (Captioned by AI)889×259 11.5 KB

Input:

DT1

The image is a screenshot of an Excel spreadsheet with three columns labeled "ID," "Name," and "Age," containing three rows of data with IDs 1, 2, and 3, names John, Lemon, and Same, and ages 34, 35, and 36 respectively. (Captioned by AI)

DT2

The image shows a blank Excel spreadsheet with columns labeled "Name," "Address," and "Age." (Captioned by AI)

Output:

The image shows a spreadsheet with three columns labeled "Name," "Address," and "Age," where the names "John," "Lemon," and "Same" have corresponding ages of 34, 35, and 36, but the "Address" column is empty. (Captioned by AI)

Regards,

8

i have run the invoke code. The data remove the header. All of the data is written starting at first row.

9

Hello @zaffan.isa ,

For what I understood you just want to insert all the rows from excel 1 on excel 2, based on the column name.

You can find a Xaml attached with a solution. You can improve the solution with LINQ if you prefer.

If you have any doubt feel free to reach me.

Example.xaml (9.0 KB)

10

@zaffan.isa

Can you please share your xaml file

Regards,

11

i forgot to declare the DT, my apologies.

But now, i am having another problem is that the written data is overwrite my header.

I am sorry i cannot share the xaml. Because it contain confidential information

12

i will try. thanks for suggest

13

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