Removing Spaces where there is no Data

[kabibi15]

Hello Everyone,

Is there any syntax in Qlik Sense that will removed spaces like this. I appreciate your help.

[melissapluke]

What would you want it to be? You can choose not to load the entire row if you would like, but if you have columns that have data associated with that row then they would not get loaded either. If you can provide a sample data set and point out the issue, that would help.

[melissapluke]

If you indeed do not want to load any of the data associated with the lines that have spaces, you can do this for each field that has spaces in it:

LOAD
A,
B,
C
FROM [lib://downloads/test.xlsx]
(ooxml, no labels, table is Sheet1)
Where not A=' ' and not B=' ';