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.
Solved! Go to Solution.
@Punit_Kapadia
the issue here is you cannot have the different headers one after the other in same column
of you join the data it makes more sense to me
or what I suggest it you can use output tool capabilities to write this in this format.
Thanks Raj!