topic Re: Role of 'MaxLine' parameter in QlikView

Role of 'MaxLine' parameter

Anonymous — Sat, 31 Jan 2015 15:06:44 GMT

While loading data from Xcel files I see an option called 'MaxLine' which is set to 1 by default.

Can anyone explain how this option is useful ?

Thanks !!

Re: Role of 'MaxLine' parameter

jonasheisterkam — Sat, 31 Jan 2015 15:40:02 GMT

If you dont want a long list you can enter a bigger value, the Fields listet like below:

LOAD B, C, D, E, F, G, H, I, J, K, L,

M, N, O, P, Q, R, S, T, U, V, W,

X, Y, Z, AA, AB, AC, AD, AE, AF,

AG, AH, AI, AJ, AK, AL, AM, AN,

AO, AP, AQ, AR, AS, AT, AU, AV,

AW, AX, AY, AZ, BA, BB, BC, BD,

BE, BF, BG, BH, BI, BJ, BK, BL,

BM, BN, BO, BP, BQ, BR, BS, BT,

BU, BV, BW, BX, BY, BZ, CA, CB,

CC, CD, CE, CF, CG, CH, CI, CJ,

CK, CL, CM, CN, CO, CP, CQ, CR,

CS, CT, CU, CV, CW, CX, CY, CZ,

DA, DB, DC, DD, DE, DF, DG, DH,

DI, DJ, DK, DL, DM, DN, DO, DP,

DQ, DR, DS, DT, DU, DV, DW, DX,

DY, DZ, EA, EB, EC, ED, EE, EF,

EG, EH, EI, EJ, EK, EL, EM, EN,

EO, EP, EQ, ER, ES, ET, EU, EV,

EW, EX, EY, EZ, FA, FB, FC, FD,

FE, FF, FG, FH, FI, FJ, FK

FROM[Al.xlsx]

(ooxml, no labels, table is Gesamtservicelevel);

The spaces at the beginning of each row are countet also. Min one field in a row is loaded and then it is filled to the end of youre limit. The limit is number of signs.

Re: Role of 'MaxLine' parameter

maxgro — Sat, 31 Jan 2015 17:57:29 GMT

Re: Role of 'MaxLine' parameter

Anonymous — Sat, 31 Jan 2015 20:49:44 GMT

Dear Jonas and Massimo,

Many thanks for your help and answers.

I am still not very clear if I understand it right ?

So if I sent Maxline to '5' does it mean that I can only give maxmum of five fields in one line like

Load F1, F2, F3, F4, F5

F6,F7,F8,F9, F10

From A.xlsx

And later when i change the Maxline to 10 it takes all 10 fields on the same line ?

Best Regards,

M.Aushik

Re: Role of 'MaxLine' parameter

jonasheisterkam — Sat, 31 Jan 2015 21:00:09 GMT

if you set it to 5 it will fill the line to the sign 5, but it will always minimum of one field in the line.

Re: Role of 'MaxLine' parameter

Anonymous — Sat, 31 Jan 2015 21:03:26 GMT

Hi Jonas,

'if you set it to 5 it will fill the line to the sign 5 ' - does it mean till t encounters 5 delimiter signs ?

Re: Role of 'MaxLine' parameter

jonasheisterkam — Sat, 31 Jan 2015 21:23:40 GMT

The Load

LOAD A,

FROM

(ooxml, explicit labels, table is Übersicht);

Line Length:

8 //LOAD+Space+A,+Space

8 //5*Space+B,+Space

6 //5*Space+E

4 //FROM

43//FILE

45//PARAM

max. 1-8 it look like above

max. 9-10:

LOAD A,

D, E

FROM