community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Export the lower table in the Visual Query Builder

As I have a lot of documentation to write on my Alteryx process, I would like to simple copy the lower table from the Visual Query Builder :

 

2016_06_23_16_12_15_Photos.png

2 Comments
Quasar
Quasar

After you build your lower table, click on the 'SQL Editor' button and you'll see the exact SQL that your configuration has generated- there is your documentation nice and easy.

Alteryx Certified Partner

Yeah, thanks, I know that 😉  -actually  I don't use the VQB but write directly the query- but this documentation is to be read by business users without SQL skill. So, what I do is taking the SQL query, parsing it into rows with the alteryx tool to have a table. But that's quite long and I have several kind of clauses to take into account.