Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

aushikmakdoom
New Contributor III

Role of 'MaxLine' parameter

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 !!

Tags (2)
1 Solution

Accepted Solutions
jonasheisterkam
Contributor III

Re: Role of 'MaxLine' parameter

The Load

LOAD A,

     B,

     C,

     D,

     E

FROM

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

Line Length:

8 //LOAD+Space+A,+Space

8 //5*Space+B,+Space

8

8

6 //5*Space+E

4 //FROM

43//FILE

45//PARAM

max. 1-8 it look like above

max. 9-10:

LOAD A,

     B,

     C,

     D, E

FROM

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

5*Space+D,+Space+E := 9

max. 11:

LOAD A, B,

     C, D,

     E

FROM

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

LOAD+Space+A,+Space+B,+Space:= 11

max 12-13:

LOAD A, B,

     C, D, E

FROM

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

5*Space+c,+Space+D,+Space+E :=12

max 14-16:

LOAD A, B, C,

     D, E

FROM

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

max 17:

LOAD A, B, C, D,

     E

FROM

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

max 18-47:

LOAD A, B, C, D, E

FROM

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

max 48-86:

LOAD A, B, C, D, E

FROM

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

max 87-...:

LOAD A, B, C, D, E

FROM (ooxml, no labels, table is Übersicht);

9 Replies
jonasheisterkam
Contributor III

Re: Role of 'MaxLine' parameter

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.

MVP
MVP

Re: Role of 'MaxLine' parameter

0.png

2.png

aushikmakdoom
New Contributor III

Re: Role of 'MaxLine' parameter

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

jonasheisterkam
Contributor III

Re: Role of 'MaxLine' parameter

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.

aushikmakdoom
New Contributor III

Re: Role of 'MaxLine' parameter

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 ?

jonasheisterkam
Contributor III

Re: Role of 'MaxLine' parameter

The Load

LOAD A,

     B,

     C,

     D,

     E

FROM

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

Line Length:

8 //LOAD+Space+A,+Space

8 //5*Space+B,+Space

8

8

6 //5*Space+E

4 //FROM

43//FILE

45//PARAM

max. 1-8 it look like above

max. 9-10:

LOAD A,

     B,

     C,

     D, E

FROM

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

5*Space+D,+Space+E := 9

max. 11:

LOAD A, B,

     C, D,

     E

FROM

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

LOAD+Space+A,+Space+B,+Space:= 11

max 12-13:

LOAD A, B,

     C, D, E

FROM

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

5*Space+c,+Space+D,+Space+E :=12

max 14-16:

LOAD A, B, C,

     D, E

FROM

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

max 17:

LOAD A, B, C, D,

     E

FROM

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

max 18-47:

LOAD A, B, C, D, E

FROM

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

max 48-86:

LOAD A, B, C, D, E

FROM

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

max 87-...:

LOAD A, B, C, D, E

FROM (ooxml, no labels, table is Übersicht);

jonasheisterkam
Contributor III

Re: Role of 'MaxLine' parameter

It is the fifth sign not Fields, it is to use the minimum place without scrolling to the right. Most code editors using styles with same width of each caracter so you can create a block wich use youre full display size without horizen scrolling. there are also some editors wich create a new line if you get to the right of the display, if youlimit it that no automatic linefeet is generatett it looks all the same. The line numbers and the reading is not changing.

aushikmakdoom
New Contributor III

Re: Role of 'MaxLine' parameter

Dear Jonas,

It is clear now...many many thanks for your details answer and time...

aushikmakdoom
New Contributor III

Re: Role of 'MaxLine' parameter

Much appreciated!!!

Community Browser