I would appreciate your help and guide on creating Flat File Schema for the below file, I have also attached the image for more clarity. The major problem is that REPEATING RECORD section (DETAILS) is extended and splited into 2 lines in pair for every record. Please provide your comment. or link to Sample or artical have same issue.
================================================================================
HEADER;X;9A01500177 ;26012015 ;AAA16XXX0373 ; Customer1 Name ; ;w2344; XX ; RM; ; DETAIL;CN77700122 ;9996001; 4191WU ;PRODUCT1 ;NR; 0000111888,0000000; 0000000000,1611000; 0000018025,16;00,00; XXXX .8/C ; 000,00; ; DETAIL;000;000;000;INFO ;0002;INFO ;TO; 0000000001,4450000; 0000000017,0070000; DETAIL;CN77700122 ;9996001; 4191WU ;PRODUCT2 ;NR; 0000111888,0000000; 0000000000,1611000; 0000018025,16;00,00; XXXX .8/C ; 000,00; ; DETAIL;000;000;000;INFO ;0002;INFO ;TO; 0000000001,4450000; 0000002918,0095000; DETAIL;CN77700122 ;9996001; 4191WU ;PRODUCT2 ;NR; 0000047952,0000000; 0000000000,1611000; 0000007725,07;00,00; XXXX .8/C ; 000,00; ; DETAIL;000;000;000;INFO ;0002;INFO ;TO; 0000000001,4450000; 0000002918,0095000; DETAIL;CN77700122 ;9996001; 4191WU ;PRODUCT4 ;NR; 0000047952,0000000; 0000000000,1611000; 0000007725,07;00,00; XXXX .8/C ; 000,00; ; DETAIL;000;000;000;INFO ;0002;INFO ;TO; 0000000001,4450000; 0000002918,0095000; DETAIL; ;00000;000; ;0000; ; ;Address1 ; ; 0000000000,0000000; 0000000000,0000000; DETAIL; ;00000;000; ;0000; ; ;Address2 ; ; 0000000000,0000000; 0000000000,0000000; DETAIL; 0000029999,6580000; 0000000000,0000000; 0000027281,3200000;
================================================================================================================================================================
File: http://ift.tt/160CkCx
-Thanks asam
No comments:
Post a Comment