Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kabibi15
Contributor III
Contributor III

Removing Spaces where there is no Data

Hello Everyone,

 

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

11 Replies
melissapluke
Partner - Creator
Partner - Creator

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
Partner - Creator
Partner - Creator

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=' ';