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

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

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.