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.
Find more posts tagged with
Sort by:
1 - 4 of
41
New Altair Community Member
OPHi FBT,
Can you provide an example for "putting strings in quotation marks"? I'm new and not sure how to do this.
Thanks!
John
New Altair Community Member
Like this from your example above:
if(INDUSTRY3=="TEXT",3,if(INDUSTRY2=="TEXT",2,1))
I also tried this but it also didn't work...
if(contains(INDUSTRY3,""),3,if(contains(INDUSTRY2,""),2,1))