9 Replies Latest reply: Jan 31, 2015 5:20 PM by Aushik Makdoom RSS

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

        • Re: Role of 'MaxLine' parameter
          Jonas Heisterkamp

          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

            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
                Jonas Heisterkamp

                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

                    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
                        Jonas Heisterkamp

                        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.

                      • Re: Role of 'MaxLine' parameter
                        Jonas Heisterkamp

                        The Load

                        LOAD A,

                             B,

                             C,

                             D,

                             E

                        FROM

                        [C:\Users\Heisterkamp\Desktop\Inbound.xlsx]

                        (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

                        [C:\Users\Heisterkamp\Desktop\Inbound.xlsx]

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

                         

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

                         

                        max. 11:

                        LOAD A, B,

                             C, D,

                             E

                        FROM

                        [C:\Users\Heisterkamp\Desktop\Inbound.xlsx]

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

                         

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

                         

                         

                        max 12-13:

                         

                        LOAD A, B,

                             C, D, E

                        FROM

                        [C:\Users\Heisterkamp\Desktop\Inbound.xlsx]

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

                         

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

                         

                        max 14-16:

                         

                        LOAD A, B, C,

                             D, E

                        FROM

                        [C:\Users\Heisterkamp\Desktop\Inbound.xlsx]

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

                         

                        max 17:

                         

                        LOAD A, B, C, D,

                             E

                        FROM

                        [C:\Users\Heisterkamp\Desktop\Inbound.xlsx]

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

                         

                        max 18-47:

                         

                        LOAD A, B, C, D, E

                        FROM

                        [C:\Users\Heisterkamp\Desktop\Inbound.xlsx]

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

                         

                        max 48-86:

                         

                        LOAD A, B, C, D, E

                        FROM [C:\Users\Heisterkamp\Desktop\Inbound.xlsx]

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

                         

                        max 87-...:

                         

                        LOAD A, B, C, D, E

                        FROM [C:\Users\Heisterkamp\Desktop\Inbound.xlsx] (ooxml, no labels, table is Übersicht);