🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Generate Attributes - function expression for "text exists"

User: "jtfields"
New Altair Community Member
Updated by Jocelyn

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.