I have below scenario
Folder 1 - Summary Data with Headers (Multiple files based on criteria "Payment Card")
| Amount | Currency | Payment Card |
| 5000 | USD | 10001 |
Folder 2 - Transaction Data with Headers (Multiple files based on criteria "Payment Card")
| Store | Type | Amount | Currency | Payment Card |
| Zara | Footwear | 1000 | USD | 1001 |
| H&M | Winterwear | 2000 | USD | 1001 |
| Ajio | Perfumes | 2000 | USD | 1001 |
Objective:
Need to combine files in folder 1 and folder 2 with below output
| Amount | Currency | Payment Card | | |
| 5000 | USD | 1001 | | |
| Store | Type | Amount | Currency | Payment Card |
| Zara | Footwear | 1000 | USD | 1001 |
| H&M | Winterwear | 2000 | USD | 1001 |
| Ajio | Perfumes | 2000 | USD | 1001 |
Output file has to be seperate for each Payment Card file.