Case Statement in Alteryx

[Ashwin1]

Hi All, 

How can i achieve this in Alteryx?

SELECT
case when A.table_name like 'Print%' THEN A.TABLE_NAME
ELSE ('PRINT_' || A.TABLE_NAME) END Table_Name
FROM Table A

Regards

Ashwin

[RolandSchubert · Accepted solution]

Hi Ashwin,

in Alteryx, in a first step you select the fields you need using INPUT tool. The changes in field "TABLE_NAME" would be achieved using a formula tool

Column (= Field): TABLE_NAME

Formula: IF StartsWith([TABLE_NAME], "Print") THEN
                   [TABLE_NAME]

               ELSE

                    "PRINT_" + [TABLE_NAME]

               ENDIF

Best regards

Roland

[Ashwin1]

Thanks RolandSchubert