AnsweredAssumed Answered

Combining two txt files to form a common CSV File

Question asked by shivpandey752937 on Jun 13, 2017
Latest reply on Jun 13, 2017 by shivpandey752937

Hi All,

 

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
1,aa,2017,08,12,12345,123456
2,ab,2016,07,13,1234,12345678

 

Detail File can be of type:

Document Number,Sequence Number,Quantity Received
aa,1,1200
ab,2,1300

 

Output CSV File shal be of type:

Store NumberDocument NumberOrder Date YearOrder Date MonthOrder Date DayVendor IDAsn IdSequence NumberQuantity Received
1aa20178121234512345611200
2ab201671312341234567821300

 

Can you please help me create a process flow for this?

 

Regards

Shivam

Outcomes