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…

Hi @0bb4628e217fd43ac86ac9294 Can you share sample input and expected output. Check this thread below too [image] Append Column Activities Hi @amitha.aenugula Can you try the below Count_DT=Excel2.Sheet("Sheet1").DataTableValue.Rows.Count+1 [image] BlankProcess20.zi…

Hi @0bb4628e217fd43ac86ac9294 Please check this [image] Append Column Activities Hi @amitha.aenugula Can you try the below Count_DT=Excel2.Sheet("Sheet1").DataTableValue.Rows.Count+1 [image] BlankProcess20.zip (287.1 KB) Output: [image] Regards, Regards,

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

@0bb4628e217fd43ac86ac9294 In Activities panel Enable Modern in Filter then you will be able to see [image]

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

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

Hi @0bb4628e217fd43ac86ac9294 Can you please share the excel files if possible. Regards

Hi @0bb4628e217fd43ac86ac9294 Main.xaml (13.0 KB) [image] 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

Excel mapping1

Help Activities

vrdabberu (Varunraj Dabberu) March 3, 2024, 2:11am 2

Hi @0bb4628e217fd43ac86ac9294

Can you share sample input and expected output.

Check this thread below too

Regards

Topic		Replies	Views
Mapping of column for 2 different excel Automation Hub question , automation_hub	5	275	April 24, 2024
Multiple Excel Data Mapping Studio datatable , excel , activities , string , question	2	1193	September 10, 2020
How to map from one excel to another excel sheet Help activities , studio	19	2925	November 27, 2018
Data Mapping from one file to another excel file with different column names Help	13	7110	August 30, 2019
Map data in excel Activities excel , activities , question	12	1692	January 29, 2022

Excel mapping1

Related topics