Excel mapping1

Help Activities
1

Hi friends i have a question and I am stuck at this point.

I have Excel1 and excel2 both the headers are different.

I need to map excel1 ColumnA data with excel2 ColumnC
excel1 ColumnB data with excel2 ColumnD
excel1 ColumnC data with excel2 ColumnE

How to do mapping of data.

Can anyone please help me. Any help will be appreciated.

2

Hi @0bb4628e217fd43ac86ac9294

Can you share sample input and expected output.

Check this thread below too

Regards

3

Hi @0bb4628e217fd43ac86ac9294

Please check this

Regards,

4

I am using studio version 2020 in that the activity u have mentioned is not there. How can I do that now

5

@0bb4628e217fd43ac86ac9294

In Activities panel Enable Modern in Filter then you will be able to see

image
image347×871 20.3 KB

6

Hi @0bb4628e217fd43ac86ac9294

Check the below zip file. This is using classic Excel activities

BlankProcess20.zip (280.1 KB)

If possible provide the input, according to that I will make the required changes and give you updated code.

Regards

8

@vrdabberu please share images I am not able to open the xaml’s

9

Hi @0bb4628e217fd43ac86ac9294

Can you please share the excel files if possible.

Regards

11

Hi @0bb4628e217fd43ac86ac9294

Main.xaml (13.0 KB)

image
image704×1258 54 KB

Copy Paste Macros Code.txt (1.0 KB)
Delete Sheet Macros Code.txt (372 Bytes)

If possible share the excel file in personal, so that I can check the excels.

Regards

12

Will try with this thank you