1) Exclude files with variable containing only empty list. 2) exclude skills that are empty list

Things I have tried

table skills
from #job_search and -"Templates"S
where skills AND (skills!=list()) AND (!contains(skills,list())) AND (length(skills)>0) AND (!contains(skills, null)) AND (skills != null)

What I’m trying to do

I want to exclude files with “skills” variable containing an empty list.

Hi @psuto ,

What does the following display for you? I think it should work for everything except excluding a file with a skills list with only one or more empty strings in it (i.e. skills: [''] won’t be excluded).

table skills
from #job_search and -"Templates"S
where skills

Hope this helps,
Jacqui

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.