Excel Value

[Sharanabasava_Kallur (Sharanabasava Kallurmath (Sdc Kolkata))]

Hi All,

I have 2 excel file(file1 and file2)
I need to reconsulation from file2 to file1
Can anyone pls guide me how to do?
challenge is file1 and file2 have same column names multiple times.

and the final file ie file1 should look like this

Please guide me on this how to do further.Thanks

[Sriharisai_Vasi]

Try using Read range and specify range A:C for file1 and H:I for second file. Now merge columns of both data tables. If column names are same then u need to use read range without headers.

[Sharanabasava_Kallur (Sharanabasava Kallurmath (Sdc Kolkata))]

Not working

[Sriharisai_Vasi]

u r trying to merge tables by rows. try merging columns by using add data column activity

[Sharanabasava_Kallur (Sharanabasava Kallurmath (Sdc Kolkata))]

This It didn’t worked

[ImPratham45 (Prathamesh Patil)]

You can use VlookUp for this in File 1

[rohith.prabhu]

Hi @Sharanabasava_Kallur,

Hope this will help you,

Read Data From One Excel and Write That Data Into Another Excel With Different Column Name

@Tushar_Gupta1 There possibly might be two ways of Performing it. Having a Excel Template ready with Headers. When using this Approach have an Excel File Ready with the Header Names present in it in the First row. After that You can use Read Range Activity to Read the Data from the Excel file as a Datatable. Then you can use Write Range Activity and specify the ExcelFile Path of the Template created. Use the Output Datatable of the Read Range as the Input for this Activity and UnCheck Add …

Thanks,
Rohith