topic how to load the excel data in QlikView

how to load the excel data

qlikviewwizard — Mon, 20 Apr 2015 11:22:40 GMT

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?

Re: how to load the excel data

PrashantSangle — Mon, 20 Apr 2015 11:26:03 GMT

Hi,

Check Enable Transformation step while loading data in qlikview.

Regards,

Re: how to load the excel data

rubenmarin — Mon, 20 Apr 2015 11:27:57 GMT

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

));

Re: how to load the excel data

buzzy996 — Mon, 20 Apr 2015 11:41:48 GMT

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.

Re: how to load the excel data

qlikviewwizard — Mon, 20 Apr 2015 11:43:30 GMT

could anyone provide the qvw file, please.

Re: how to load the excel data

buzzy996 — Mon, 20 Apr 2015 11:51:58 GMT

pfa,mark as correct if ur happy with this.

Re: how to load the excel data

PrashantSangle — Mon, 20 Apr 2015 11:58:54 GMT

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

Re: how to load the excel data

jagan — Tue, 21 Apr 2015 02:27:22 GMT

Hi,

Try this simple script

LOAD A,

QAZXCV,

ZXCVB,

AA,

AB,

AC,

AD,

AE,

AF,

AG,

AH,

AI,

AJ,

TOTAL,

AL,

AM,

AN,

AO,

TOTAL1,

AQ,

AR,

AS,

AT,

FROM

[Book1 (1).xlsx]

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

WHERE Len(Trim(A)) > 0;

Regards,

Jagan.

Re: how to load the excel data

qlikviewwizard — Tue, 21 Apr 2015 02:42:05 GMT

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

Re: how to load the excel data

kumarravi — Tue, 22 Mar 2022 16:12:38 GMT

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