This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Debating whether or not to upgrade to the latest version of Alteryx Designer?
I'm trying to calculate a new field in my In-DB workflow, but I keep getting 'Unable to prepare query' error.
I need to set this up in an In-DB workflow, as I'll be moving a rather big table within a DB, so processing outside of DB would be inefficient time-wise.
This is how my Formula In-DB is set up now - if anyone with more experience using SQL in Alteryx can help spotting what is wrong with it, I'd appreciate that very much.
To be clear - I want to create a field called 'KPCI_LEVEL' based on the values of field called 'FUNCTION_LEVEL_OBJECT'. 'FUNCTION_LEVEL_OBJECT' has numeric data type.
Thanks for suggestions - unfortunately, the query still throws errors.
I found a way to get around that - I created reference table in Text Input and joined that to my data. Who needs SQL when you have Alteryx :)