topic Loading flat file in QlikView https://community.qlik.com/t5/QlikView/Loading-flat-file/m-p/203796#M60991 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>look for "subfield" and other string functions.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Thu, 07 Jan 2010 12:29:18 GMT 2010-01-07T12:29:18Z Loading flat file https://community.qlik.com/t5/QlikView/Loading-flat-file/m-p/203795#M60990 <HTML><HEAD></HEAD><BODY><P>Hi please help.</P><P>I am trying to load flat files into Qlikview but i have hit a wall.</P><P>I have text files with fixed length with A as File Transmission Header, BC as Header 1 Record Line and ND as Detail Line.</P><P>A describes the invoice header like Header indicator, message type, System record, number of records...,</P><P>BC describes header record details like account number, invoice number, invoice date, warehouse...</P><P>and ND describes the invoice details like line number, list price, product code...</P><P>Problem is i need to link the A to BC to ND.</P><P>A typical file looks like this</P><P>A472D20100107030009000004000077 03.00<BR />BC000000000472017OKVSTE 00000047201620100106T01<BR />ND003RB32536 0000005000000406790000000000000000000000000000 000 00000000000000 000 00000000000000 000 00000000000000 000 000000000000000004067900002033990000028476<BR />BC000000000472023BUCCSP 00000047203520100106T01</P><P>ND005RB32536 0000001000000406800000000000000000000000000000 000 00000000000000 000 00000000000000 000 00000000000000 000 000000000000000004068000000406800000005695</P><P>Thanks</P></BODY></HTML> Thu, 07 Jan 2010 10:52:56 GMT https://community.qlik.com/t5/QlikView/Loading-flat-file/m-p/203795#M60990 2010-01-07T10:52:56Z Loading flat file https://community.qlik.com/t5/QlikView/Loading-flat-file/m-p/203796#M60991 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>look for "subfield" and other string functions.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Thu, 07 Jan 2010 12:29:18 GMT https://community.qlik.com/t5/QlikView/Loading-flat-file/m-p/203796#M60991 2010-01-07T12:29:18Z