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?
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