Skip to main content
Topics#TrailheadFrage von Amit Gomes
Amit Gomes (Kiwi Routes Limited) fragte in #Trailhead
13. Sept. 2021, 05:58

IF Else (Contains) statement on row level with text return

I want to use IF Else Statement on row level to return text value 

IF(CONTAINS(Asset.Name,"0301"),1,0),'EHUBO2.1'

IF(CONTAINS(Asset.Name,"0318"),1,0),'EHUBO2.0'

 

this give me a syntax erorr

Request help .

Kind Regards

Amit 

 

#Trailhead

19 Antworten
  1. Amit Gomes (Kiwi Routes Limited)
    13. Sept. 2021, 07:35

    Hey Kalpit and Kenji 

     

    IF(CONTAINS(Asset.Name,"0301"),'EHUBO2.1',
    IF(CONTAINS(Asset.Name,"0318"),'EHUBO2.0',
    NULL
    ))

     this one works . 

    but will have more question as i am still learning. 

     

    Thanks

    Amit 

Antwort schreiben...
0/9000