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.
I have been given a very complex Sql query that i have been asked to build a alteryx workflow to make it simpler to understand, however the query is about 120 lines and has many joints and unions, i was wondering if there is any tool out there that can build this or help me convert it to some stage.
the idea is to simplify the query and not to use it as a full sql query at extraction layer. please help me if you know a best way to start or achieve this. thanks in advance
Thanks for responding, sql is not problem as Im coming from Sql background. the issue is timing, the transition from old systems and queries to alteryx means i have so many old left over complex queries that i would need to create workflow for and i was just wondering if there is faster way to achieve this.
You could just paste the SQL into an input tool, at least it will be running in Alteryx and then you can do the full conversion later on (it also makes a good test harness to compare to your new workflow as well)