生成属性——功能ion expression for "text exists"

jtfieldsjtfields MemberPosts:3Contributor I
edited December 2018 inHelp

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

  • jtfieldsjtfields MemberPosts:3Contributor I

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

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

  • FBTFBT MemberPosts:106Unicorn

    Have you tried putting your strings into quotation marks?

  • jtfieldsjtfields MemberPosts:3Contributor I

    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

  • FBTFBT MemberPosts:106Unicorn

    Like this from your example above:

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

Sign InorRegisterto comment.