https://community.qlik.com/t5/Talend-Studio/tFileInputMSPositional/m-p/2318116#M88489 any help Thu, 18 Aug 2011 12:27:13 GMT Anonymous 2011-08-18T12:27:13Z https://community.qlik.com/t5/Talend-Studio/tFileInputMSPositional/m-p/2318115#M88488 Hi,<BR />Can anybody give me the details that how can I use 'tFileInputMSPosition' component.<BR />Thanks &amp; Regards,<BR />Syed Sat, 16 Nov 2024 12:44:10 GMT https://community.qlik.com/t5/Talend-Studio/tFileInputMSPositional/m-p/2318115#M88488 Anonymous 2024-11-16T12:44:10Z https://community.qlik.com/t5/Talend-Studio/tFileInputMSPositional/m-p/2318116#M88489 any help Thu, 18 Aug 2011 12:27:13 GMT https://community.qlik.com/t5/Talend-Studio/tFileInputMSPositional/m-p/2318116#M88489 Anonymous 2011-08-18T12:27:13Z https://community.qlik.com/t5/Talend-Studio/tFileInputMSPositional/m-p/2318117#M88490 Hi, <BR />Finally I am able to configure to multiple schemas and parse the records as shown in the screens. <BR />But how can I insert these data into one table. <BR />Input File Data: <BR />========== <BR /> H0 20081003SIRSSD REFRESH SRCAPCOE <BR />71657YAA0 CA00012007050171657YAA0 C 00000000 A <BR />71657YAA0 CA300120090731 141921 USEDT <BR />71657YAA0 CB0001000000600000 N1 202205082200705082007110820211108DFX <BR />71657YAA0 CB100100060430ANDN 00000001000USDUSDUSD 000000000000 <BR />71657YAA0 CB2001A AF N C N 0000000000000000 0000000000000000 00000000 <BR />71657YAA0 CB300100000001000000000001000000000001000000000000000 <BR />71657YAA0 CC4001F S 0000000000000000B B 0000000000000000 0000000000000000 <BR />71657YAA0 CDA001PETROLEUM CO TRINIDAD &amp; TOBAGO <BR />71657YAA0 CD0001PETROLEUM CO TRINIDAD &amp; TOBAGO NT 144A 6%22 <BR />71657YAA0 CD1001OUTFB N 492513 0 2 4 000010000000USD00YY TTUSY A Y <BR />71657YAA0 CD20012007050100075000000000 00000099579000USDF0 N B <BR />71657YAA0 CD3001 00075000000000 320090201 <BR />71657YAA0 CD5001C AP15 2007050800000000 B CITX N <BR />71657YAA0 CG400171657YAB8 <BR />71657YAA0 CI000120090518200911082009102300000000700000000000300000000000600000 <BR />71657YAA0 CI1001B 000 00000000000000 CN 000000000000000000 <BR />71657YAA0 CR1001SP 00000000BBB MO 00000000Baa3 00000000 <BR />71657YAA0 CS4001201011081 00000201011081000000003125000 E S 000000000000 <BR />71657YAA0 CS5001201011081000000003125000S 201105081000000003125000S <BR />71657YAA0 CS5002201111081000000003125000S 201205081000000003125000S <BR />71657YAA0 CS5003201211081000000003125000S 201305081000000003125000S <BR />71657YAA0 CS5004201311081000000003125000S 201405081000000003125000S <BR />71657YAA0 CS5005201411081000000003125000S 201505081000000003125000S <BR />71657YAA0 CS5006201511081000000003125000S 201605081000000003125000S <BR />71657YAA0 CS5007201611081000000003125000S 201705081000000003125000S <BR />71657YAA0 CS5008201711081000000003125000S 201805081000000003125000S <BR />71657YAA0 CS5009201811081000000003125000S 201905081000000003125000S <BR />71657YAA0 CS5010201911081000000003125000S 202005081000000003125000S <BR />71657YAA0 CS5011202011081000000003125000S 202105081000000003125000S <BR />71657YAA0 CS5012202111081000000003125000S 000000000000000000000000 <BR />71657YAA0 CX000171657YAA0 029994170 B1WV706US71657YAA01 <BR />71657YAA0 CX4001 <BR /> T0 011011622008100615:44:45USEDT <BR /> <BR />Thanks &amp; Regards, <BR />Syed Fri, 19 Aug 2011 10:34:18 GMT https://community.qlik.com/t5/Talend-Studio/tFileInputMSPositional/m-p/2318117#M88490 Anonymous 2011-08-19T10:34:18Z https://community.qlik.com/t5/Talend-Studio/tFileInputMSPositional/m-p/2318118#M88491 As shown in the output <BR />71657YAA0|C|A0|001|20070501<BR />71657YAA0|C|A3|001|20090731<BR />How do I store these two records into one table based on matching '71657YAA0' Fri, 19 Aug 2011 10:39:34 GMT https://community.qlik.com/t5/Talend-Studio/tFileInputMSPositional/m-p/2318118#M88491 Anonymous 2011-08-19T10:39:34Z