Merge_excel

Learning & Development Programs Automation Starter
1

i want workflow of merge two excel into one excel

2

@Yogita_Gaikwad
please check Here I am merging multiple files
Systems1_MargeMonthlyReports.xaml (15.7 KB)

3

which package i need to install for this?

4

@Yogita_Gaikwad
image

5

Hello @Yogita_Gaikwad

You can watch the below video. Used Modern activities for this.

Thanks

6

first excel

Name location state number
yogita Nashik Maharashtra 2637389
Neha pune goa 253638
priya mumbai karnataka 748932
Akshay Kalkatta xyz 766655

second excel

ZipCode office_location Amount
1234 satana 40
6789 dhule 67
9876 hydrabad 23

suppose i want to merge these two excel for different column name

output***********

Name location state number ZipCode office_location Amount
yogita Nashik Maharashtra 2637389 1234 satana 40
Neha pune goa 253638 6789 dhule 67
priya mumbai karnataka 748932 9876 hydrabad 23 Akshay
7

Hello @Yogita_Gaikwad

Can you please share the expected output as well? Because in your files shared, there are no unique key to make a connection.

Thanks