Generate Attributes - function expression for "text exists"
I'm trying to write an expression to determine if data exists in the Industry 1, Industry 2 or Industry 3 attributes. I wrote the following expression to load a 1, 2 or 3 in a new attribute Number of Industries. Where I have "TEXT", I need an expression to determine if text data exists...
if(INDUSTRY3==TEXT,3,if(INDUSTRY2==TEXT,2,1))
I'm a newbie so any help is appreciated.