Merge_excel

i want workflow of merge two excel into one excel

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

which package i need to install for this?

@Yogita_Gaikwad
image

Hello @Yogita_Gaikwad

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

Thanks

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

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