topic Delete empty excels rows in QV in QlikView

Delete empty excels rows in QV

Tue, 11 Nov 2014 13:33:47 GMT

Hey QV community,

I have a question, how it is possible that I can delete empty Excel rows while I am loading in QV? Of course I can delete this rows in Excel but this is might too easy.

Re: Delete empty excels rows in QV

its_anandrjs — Tue, 11 Nov 2014 13:39:50 GMT

Hi,

Click on the cross symbol near F4 and F5 and that columns not loaded in the script or you can also comment this ion script

LOAD Saion,

Spieler,

Tore

//F4,

//F5

FROM

Test.xlsx

(ooxml, embedded labels, table is Tabelle1);

Regards

Anand

Re: Delete empty excels rows in QV

its_anandrjs — Tue, 11 Nov 2014 13:42:22 GMT

And also if want to remove null values from the rows then load like

LOAD Saion,

Spieler,

Tore

//F4,

//F5

FROM

Test.xlsx

(ooxml, embedded labels, table is Tabelle1)

Where Len(Trim(Spieler)) > 0 or Len(Trim(Tore)) > 0 or Len(Trim(Saion)) > 0;

Regards

Anand

Re: Delete empty excels rows in QV

Tue, 11 Nov 2014 13:43:51 GMT

Hey Anand,

thank you for your help!

Justin