Generate Attributes - function expression for "text exists"

jtfields
jtfields New Altair Community Member
edited November 5 in Community Q&A

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.

Tagged:

Answers

  • jtfields
    jtfields New Altair Community Member

    I also tried this but it also didn't work...

     

    if(contains(INDUSTRY3,""),3,if(contains(INDUSTRY2,""),2,1))

  • FBT
    FBT New Altair Community Member

    Have you tried putting your strings into quotation marks?

  • jtfields
    jtfields New Altair Community Member

    Hi FBT,

     

    Can you provide an example for "putting strings in quotation marks"?  I'm new and not sure how to do this.

     

    Thanks!

    John

  • FBT
    FBT New Altair Community Member

    Like this from your example above:

     

    if(INDUSTRY3=="TEXT",3,if(INDUSTRY2=="TEXT",2,1))

Categories