I need some help on a quite simple subject.
I want to add a new calculated column to a datatable according to other string columns.
Simple example :
If(upper(colX) like “TOTO*” then “OK” else “KO”)
I found this, but it doesn’t work : IIF(UPPER([colX]) like “TOTO*”, “OK”, “KO”)
How to specify this calculation in the default argument ?
What type for Default argument (String ? Object ?) ?