Howto load text file with fixed and variable part

peterwh — Tue, 15 May 2012 12:49:00 GMT

Hello,

I'm getting the same error message as in "Too complex, more than 100 levels nesting", but my problem is, I don't have any idea how to make a better solution. So does anyone have a - maybe simplier - solution for the following problem:

I have to read a txt-file (separated by ";") with a fixed part and a variable part. The number of columns is defined by a value in the fixed part. I have to get a table where for every value is in a separated line with a changed Timestamp.

At the moment I make it with variables and nested-ifs where IterNo() is the condition and the timestamp-calculation is based on IterNo() too.

Example txt-File:

Counter; Timestamp ; NoOfValues; V1; V1Flag; V2; V2Flag;...... Vn; VnFlag;

4711 ; 01.01.12 01:00 ; 24 ; 10; W ; 20; W ;......

4712 ; 01.01.12 00:15 ; 96 ; 15; W ; 10; F ;........

Result:

Counter; Timestamp ; Value; ValueFlag;

4711 ; 01.01.12 01:00 ; 10 ; W ;

4711 ; 01.01.12 02:00 ; 20 ; W ;

...

4711 ; 02.01.12 00:00 ; 30 ; W ;

4712 ; 01.01.12 00:15 ; 15 ; W ;

4712 ; 01.01.12 00:30 ; 10 ; F ;

...

4712 ; 02.01.12 00:00 ; 20 ; W ;

Thanks in advance for any help.

Peter

Howto load text file with fixed and variable part

Jason_Michaelides — Tue, 15 May 2012 13:50:59 GMT

Look up CrossTable() in the reference manual. If you need further help let us know.

Jason

Howto load text file with fixed and variable part

vlad_komarov — Tue, 15 May 2012 17:03:50 GMT

You can use default QV CrossTable functionality or use third party products, this one for example:

http://www.dbsoftlab.com/etl-tools/qlikview-connector/overview.html

topic Howto load text file with fixed and variable part in QlikView

Howto load text file with fixed and variable part

Howto load text file with fixed and variable part

Howto load text file with fixed and variable part