Need help with Find & Replace Excel Activity

Hi, I’m using Find & Replace excel activity for Finding all the column names in Excel A and Replace them in Excel B.
In Excel A, I want to fetch all the column names horizontally, in Excel B I have the names to be replaced in one single column vertically.

None of my equations is helping me get the work done.
Please help…

Hi @Jnana_S_Rao

Please refer to the attached sample workflow, hope you can solve your problem

Main.xaml (8.2 KB)
testExcel.xlsx (8.9 KB)

Br,
Goutham

1 Like

Hi, @GouthamVijay thanks for your response.

I tried your way, however, instead of replacing the column names, it is getting appended.

I’m sharing my workflow and related excel files. Please look into it.

Thanks.

Header_Data.xlsx (9.7 KB)
Sample_A.xlsx (9.3 KB)
Sequence_Test.xaml (7.5 KB)

Hey @Jnana_S_Rao

I am not clear with the replacing in second excel…

Could you provide me the steps to follow…

Hi @GouthamVijay,

Here’s what I need to achieve:

Sample_A file has some data with 7 Columns, I have to replace these column names as specified in Header_Data file.

As you can see Header_Data file has 2 columns.
One is the Original (the column names of Sample_A file), the other one is Change To (these will be the new column names for Sample_A file).

I hope this will help you understand my query.

1 Like

Please find the updated attached solution, hope it helps…

Header_Data.xlsx (9.7 KB)
Sample_A.xlsx (9.3 KB)
Sequence_Test.xaml (11.9 KB)

Br,
Goutham

@GouthamVijay It works! Thanks a lot, Pal :raised_hands:

1 Like

Most Wc :slight_smile:

PLEASE HELP me; I have to get the data from more than one excel in the file. URGENT please help please…

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