tFileInputMSPositional

Hi,
Can anybody give me the details that how can I use 'tFileInputMSPosition' component.
Thanks & Regards,
Syed
3 REPLIES

Re: tFileInputMSPositional

any help

Re: tFileInputMSPositional

Hi,
Finally I am able to configure to multiple schemas and parse the records as shown in the screens.
But how can I insert these data into one table.
Input File Data:
==========
H0 20081003SIRSSD REFRESH SRCAPCOE
71657YAA0 CA00012007050171657YAA0 C 00000000 A
71657YAA0 CA300120090731 141921 USEDT
71657YAA0 CB0001000000600000 N1 202205082200705082007110820211108DFX
71657YAA0 CB100100060430ANDN 00000001000USDUSDUSD 000000000000
71657YAA0 CB2001A AF N C N 0000000000000000 0000000000000000 00000000
71657YAA0 CB300100000001000000000001000000000001000000000000000
71657YAA0 CC4001F S 0000000000000000B B 0000000000000000 0000000000000000
71657YAA0 CDA001PETROLEUM CO TRINIDAD & TOBAGO
71657YAA0 CD0001PETROLEUM CO TRINIDAD & TOBAGO NT 144A 6%22
71657YAA0 CD1001OUTFB N 492513 0 2 4 000010000000USD00YY TTUSY A Y
71657YAA0 CD20012007050100075000000000 00000099579000USDF0 N B
71657YAA0 CD3001 00075000000000 320090201
71657YAA0 CD5001C AP15 2007050800000000 B CITX N
71657YAA0 CG400171657YAB8
71657YAA0 CI000120090518200911082009102300000000700000000000300000000000600000
71657YAA0 CI1001B 000 00000000000000 CN 000000000000000000
71657YAA0 CR1001SP 00000000BBB MO 00000000Baa3 00000000
71657YAA0 CS4001201011081 00000201011081000000003125000 E S 000000000000
71657YAA0 CS5001201011081000000003125000S 201105081000000003125000S
71657YAA0 CS5002201111081000000003125000S 201205081000000003125000S
71657YAA0 CS5003201211081000000003125000S 201305081000000003125000S
71657YAA0 CS5004201311081000000003125000S 201405081000000003125000S
71657YAA0 CS5005201411081000000003125000S 201505081000000003125000S
71657YAA0 CS5006201511081000000003125000S 201605081000000003125000S
71657YAA0 CS5007201611081000000003125000S 201705081000000003125000S
71657YAA0 CS5008201711081000000003125000S 201805081000000003125000S
71657YAA0 CS5009201811081000000003125000S 201905081000000003125000S
71657YAA0 CS5010201911081000000003125000S 202005081000000003125000S
71657YAA0 CS5011202011081000000003125000S 202105081000000003125000S
71657YAA0 CS5012202111081000000003125000S 000000000000000000000000
71657YAA0 CX000171657YAA0 029994170 B1WV706US71657YAA01
71657YAA0 CX4001
T0 011011622008100615:44:45USEDT

Thanks & Regards,
Syed

Re: tFileInputMSPositional

As shown in the output
71657YAA0|C|A0|001|20070501
71657YAA0|C|A3|001|20090731
How do I store these two records into one table based on matching '71657YAA0'