Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

SQL Query Issue: Function to convert value of a single-select enumeration field to text

amir_saran
5 - Atom

I am able to successful connect to the database that contains my data and have run successful queries using that database but I keep getting an error when I try to use the SQL function to convert the enumeration value to text. The function that typically does this in other query editors is OP_RPS_AUX.CONVERT_EVIDLIST_TO_NAME 

 

For example, here is a simple SQL query that has this issue: 

 

SELECT NAME00

,CTRLGRP

,OP_RPS_AUX.CONVERT_EVIDLIST_TO_NAME (CTRLGRP)

FROM RT_CONTROL

 

This does not successfully run but if I get rid of the enumeration to text function, it runs easily. Is there anyone that could fix this for me please?

 

3 REPLIES 3
Watermark
11 - Bolide

Just convert it to text after you've pulled it into alteryx. 

ncrlelia
11 - Bolide

Hi @amir_saran,

 

You can try CONVERT(VARCHAR(20), FORMAT(CTRLGRP, 'N')).

Hope this helps.

 

Best Regards,

Lelia

apathetichell
17 - Castor

Can you confirm that your database that you are accessing data in is an IBM db? I do not believe that function is universal especially in contemporary SQL.

Labels