I have a requirement where i have to pick up two files one Header File and One Detail File. Both these files have a common Column known as Document Number. Now my objective is to create a single CSV File which will have data for both Header and Detail Files for each document number.
Header File can be of type:
Store Number,Document Number,Order Date Year,Order Date Month,Order Date Day,Vendor ID,Asn Id
Detail File can be of type:
Document Number,Sequence Number,Quantity Received
Output CSV File shal be of type:
|Store Number||Document Number||Order Date Year||Order Date Month||Order Date Day||Vendor ID||Asn Id||Sequence Number||Quantity Received|
Can you please help me create a process flow for this?