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?
Just convert it to text after you've pulled it into alteryx.
Hi @amir_saran,
You can try CONVERT(VARCHAR(20), FORMAT(CTRLGRP, 'N')).
Hope this helps.
Best Regards,
Lelia
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.