topic Re: How to import a txt file (without any delimiters and column labels) into Qlikview in QlikView

How to import a txt file (without any delimiters and column labels) into Qlikview

Mattia — Sat, 16 Nov 2024 19:52:49 GMT

Hi everyone,

i'm new in Qlikview and i need to import, every months, a txt file like the one that is attached (with more rows), with the same structure, lenght, data type and fields.

I've two problems:

1) How can i import the data creating a layout (because the file don't have any delimiters)? E.g. 1st column (lenght: 3, from 1 to 3, data type: text), 2nd column (lenght: 6, from 4 to 9, data type: number), 3rd column (lenght: 8, from 10 to 17, data type: text) and so on. Also blanks are columns (of course, without data). Until now, i've used Access, that allow me to create a layout by select and insert single lines/delimiters that separates the fields/column (each with a fixed/default number of characters, defined in the import requirements).

2) How can i embed column labels in this layout, in order not to repeat the same step every single month with the next data file? e.g. 1st column (label: AAAA), 2nd column (label: BBBB), 3rd column (label: CCCC) and so on.

Please, help me!!!

Thanks,

Mattia

Re: How to import a txt file (without any delimiters and column labels) into Qlikview

Frank_Hartmann — Thu, 17 Oct 2019 12:36:36 GMT

try this:

LOAD [@1:3] as column1, [@4:9] as column2, [@10:17] as column3, [@18:n] as column4 FROM [C:\Users\admin\Desktop\Sample_for_Qlikview.txt] (fix, codepage is 1252);

Re: How to import a txt file (without any delimiters and column labels) into Qlikview

Mattia — Thu, 17 Oct 2019 13:00:05 GMT

Hi Frank and thanks for the fast reply.

I've tried your solution but, when i reload the script, is displayed a script error "Field not found error - Field '@1:3' not found".

How can we solve it?

Thanks,

Mattia

Re: How to import a txt file (without any delimiters and column labels) into Qlikview

Frank_Hartmann — Thu, 17 Oct 2019 13:03:16 GMT

you need to split the fields like this:

Re: How to import a txt file (without any delimiters and column labels) into Qlikview

Mattia — Thu, 17 Oct 2019 13:26:11 GMT

Oh, yes! Thanks for the video tutorial, Frank! Now, it works.

Thank you SO much for taking the time to point me in the right direction.

In the next month, when i'll have another txt file, i'll need to rewrite the script or i'll just import the txt file under this script in a similar way to concatenating tables (because iìll have the same structure, fields and characters)?

If i need your help for another problem, can i send you a private message?

Have a nice day!

Mattia

Re: How to import a txt file (without any delimiters and column labels) into Qlikview

Frank_Hartmann — Thu, 17 Oct 2019 13:54:58 GMT

if your next month txt file has the same structure you can use the same script

and, like you said, just concatenate the two tables.

If you need assistance feel free to send me a private message