Get Column Name and Paste Data to Another Excel File Column

[Shoji (Shoji Yamada)]

What I’m trying to do is get the specific column name from an excel file, copy its content and paste it to another column in the other excel file.

In here I want to get only the customer ID and Customer Name (I want to get the column name not the range since I want it to be dynamic)

Then I want to paste the Customer ID and Customer Name data to another Excel File Column named Account Number and Name

Final Output look like this

I am using Excel Activity.

First I’m reading the entire excel then saves it to my variable

Then use Filter Data Table to get only the “Customer ID” and “Customer Name” Column

Finally I am using another excel file then write my dt variable to that excel file

My problem is I don’t know how to map the “Customer ID” and “Customer Name” from my previous excel file and paste its data to the “Account Number” and “Name” in another excel file. Right now, I am using range but I want to use column name instead.

The output is wrong

,

[lchirathapudi (Pallavi Chirathapudi)]

Hi @Shoji

Try this

Sequence2.xaml (14.1 KB)

Output:

Regards,

[Shoji (Shoji Yamada)]

Hello, Thank you for the help.

Although this one works, the problem is my source excel file sometimes change the position of columns.

For example, the Customer Name Column is at the end

Now, If I follow what you provided me the output look like this now

That’s why I want to get the Column Name instead of the Range.

[lchirathapudi (Pallavi Chirathapudi)]

@Shoji

How about the following?

Sequence2.xaml (15.4 KB)

Output:

Regards,

[Shoji (Shoji Yamada)]

This one solves my problem, thank you very much