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: 
Not applicable

Delete empty excels rows in QV

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.

1 Solution

Accepted Solutions
its_anandrjs

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

View solution in original post

3 Replies
its_anandrjs

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

its_anandrjs

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

Not applicable
Author

Hey Anand,

thank you for your help!

Justin