cast or convert wont work at sql server for converting float to nvarchar
cast([Column_Name] as nvarchar(10)) result would not be as expected.
Use “str” function.
Month: July 2017
Tableau – if null yes or no
below is the syntax to get yes value when value of a field is null.
IF
isnull([Field_Name]) then ‘No’
else ‘Yes’
END
Data Engineering and BI BLOG 