This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I need to some information from a text file and am getting confused about where to go next.
The file is similar to the attached, although this is obviously sample data and the real file has a lot more fields.
The only information I need is the Code, the ID, and the Comments out of this.
I've managed to load the file using:
TEMP2: LOAD If(@1='Code',@1) as Code, If(@1='Comments',@1) as Comment, If(@1='ID',@1) as ID, @2 as Result FROM [SiteTest.txt] (txt, codepage is 1252, no labels, delimiter is '=', header is 1 lines) WHERE @1='Code' or @1 = 'Comments' or @1 = 'ID'
but this clearly gives me the information unattached to itself.
Any steers in the right direction would be most gratefully received.
If(IsNull(Code), Peek(Code), Code) as Code,
If(IsNull(ID), Peek(ID), ID) as ID
If(@1='Code', @2) as Code,
If(@1='Comments', @2) as Comments,
If(@1='ID', @2) as ID
(txt, codepage is 1252, no labels, delimiter is '=', msq)
Where Match(@1, 'Code', 'Comments', 'ID');
Where not IsNull(Comments)
DROP table test;
View solution in original post
Perfect! Thank you very much.
Then...the customer tells me that actually, that text file was a database extract...from a database I was already connecting to!