Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
Hey Anand,
thank you for your help!
Justin