Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

1 Solution

Accepted Solutions
jonasheisterkam
Partner - Creator III
Partner - Creator III

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);

View solution in original post

9 Replies
jonasheisterkam
Partner - Creator III
Partner - Creator III

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.

maxgro
MVP
MVP

0.png

2.png

Anonymous
Not applicable
Author

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
Partner - Creator III
Partner - Creator III

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.

Anonymous
Not applicable
Author

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
Partner - Creator III
Partner - Creator III

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
Partner - Creator III
Partner - Creator III

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.

Anonymous
Not applicable
Author

Dear Jonas,

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

Anonymous
Not applicable
Author

Much appreciated!!!