Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a simple csv file that contains the Category Parent, Category, Material
No matter what I try, Qlik is loading materials that have a blank category (these cells are empty in excel, and expressed as null in Qlik). I just want the record that have a category loaded.
I've tried the following, but no matter what I do these null records continue be created --- any suggestions?
1. filtered on category ='E1'
2. filtered on len(trim(category))>0
3. filtered on not(category)=''
4. filtered on isnull(category)=0
The len(trim(category))>0 should work it is pretty generic. What's the output of the field [TEST] when running the script below?
Load [Category Parent], Category, Material,
len(trim(Category))>0 as [TEST]
FROM LIB://.../Simple.csv (txt...)
Where len(trim(Category))>0
The len(trim(category))>0 should work it is pretty generic. What's the output of the field [TEST] when running the script below?
Load [Category Parent], Category, Material,
len(trim(Category))>0 as [TEST]
FROM LIB://.../Simple.csv (txt...)
Where len(trim(Category))>0
Hey Vegar -- thank you for the quick reply. It seems the underlying issue was with a join. I needed to expand the filter to one more field due to another set of blanks, after applying len(trim(category))>0 and len(trim(material))>0, the results were correct.
Thanks for your help!