is null

[amir0606]

If I want to write according to this syntax, how do I write down the formula?

sql:

dont work:

IF [BTL_Status]=3 THEN
if IsNull([BTL_Leave_Date]) then [BTL_Capitation_Leave_and_Join_Date] ENDIF)
ELSE ''

ENDIF

[binuacs]

@amir0606 

IF [BTL_Status] = 3 Then
  IF isNull([BTL_Leave_Date]) Then [BTL_Capitation_Leave_and_Join_Date] ELSE '' EndIF
Else
''
EndIF

OR


IF [BTL_Status] = 3 AND isNull([BTL_Leave_Date]) Then [BTL_Capitation_Leave_and_Join_Date] ELSE 
""
EndIF

[amir0606]

f I want to use the cast function like SQL, which function is it in altrix?

[binuacs]

@amir0606 toString() function to convert the data into string type, then toNumber() , for converting the date to string type you need to use the DateTimeFormat() function, again to convert string to date type you need to you DateTimeParse() function

https://help.alteryx.com/20231/designer/string-functions