how to load the excel data

[qlikviewwizard]

Hi All,

How to load the row number 6 as header, excluding 7 to 11 rows, from 12 and 13 are the data values of attached excel file?

[PrashantSangle]

Hi,

Check Enable Transformation step while loading data in qlikview.

Regards,

[rubenmarin]

Hi, hope this helps:

LOAD ...

FROM

[.\Book1.xlsx]

(ooxml, embedded labels, header is 4 lines, table is Sheet1, filters(

Remove(Row, Pos(Top, 6)),

Remove(Row, Pos(Top, 5)),

Remove(Row, Pos(Top, 4)),

Remove(Row, Pos(Top, 3)),

Remove(Row, Pos(Top, 2))

));

[buzzy996]

try this way,

1. QlikView Edit script

2.Table files---select ur excel file

3. Lables as Explicit and  Header size Lines as 5

4. Next---Next

5. clikc on Where tab- select field as A and  OP/FUNC= IS NOT NULL

6. ok--finish and load ur data.

[qlikviewwizard]

could anyone provide the qvw file, please.

[buzzy996]

pfa,mark as correct if ur happy with this.

[PrashantSangle]

Hi,

Use below script

Test:
LOAD A,
     B,
     C,
     D,
     E,
     QAZXCV,
     G,
     H,
     I,
     J,
     K,
     L,
     M,
     N,
     O,
     P,
     Q,
     R,
     S,
     T,
     ZXCVB,
     V,
     W,
     X,
     Y,
     Z,
     AA,
     AB,
     AC,
     AD,
     AE,
     AF,
     AG,
     AH,
     AI,
     AJ,
     TOTAL,
     AL,
     AM,
     AN,
     AO,
     TOTAL1,
     AQ,
     AR,
     AS,
     AT,
     AU
FROM
Book1.xlsx
(ooxml, embedded labels, header is 4 lines, table is Sheet1, filters(
Remove(Row, Pos(Top, 6)),
Remove(Row, Pos(Top, 5)),
Remove(Row, Pos(Top, 4)),
Remove(Row, Pos(Top, 3)),
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top, 4))
));

Regards

[jagan · Accepted solution]

Hi,

Try this simple script

LOAD A,

     B,

     C,

     D,

     E,

     QAZXCV,

     G,

     H,

     I,

     J,

     K,

     L,

     M,

     N,

     O,

     P,

     Q,

     R,

     S,

     T,

     ZXCVB,

     V,

     W,

     X,

     Y,

     Z,

     AA,

     AB,

     AC,

     AD,

     AE,

     AF,

     AG,

     AH,

     AI,

     AJ,

     TOTAL,

     AL,

     AM,

     AN,

     AO,

     TOTAL1,

     AQ,

     AR,

     AS,

     AT,

     AU

FROM

[Book1 (1).xlsx]

(ooxml, embedded labels, header is 4 lines, table is Sheet1)

WHERE Len(Trim(A)) > 0;

Regards,

Jagan.

[qlikviewwizard]

Thank you so much Shiva Reddy,Ruben,max dreamer and Jagan.

[kumarravi]

Follow the step ⬇️:

1. Press Ctrl+E  // It will open the Script editor

2. Click the Table in the bottom right side

3. Choose the File you want to upload

4. If you have Embedded Headers, choose the selection as per requirement

5. Click finish.

You are ready to go !!😁