Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Changes to word-wrap in SQL Query window

the SQL Editing screen has recently been changed (thank you @JPoz  and team!) - and now has syntax indenting and keyword coloring.

 

Could I ask for a minor change:

- The tool seems to be doing a word-wrap even if the container doesn't need it - for example in the screenshot below, the entire on clause can fit on one line because I've expanded the window so that it doesn't need to wrap.

- Could you also default to putting the ON clause for a join 4 spaces indented underneath the join clause?   worked example below.

 

Wordwrap:

 

SQL Query Wordwrap.png

 

Indenting Structure:

 

Could we use a default structure for queries where the on part is indented underneath the Join?

 

Select

    Field1,

    Field2,

    field3

from

    Table1

    inner join table2

        On Table1.key = table2.key

        and table1.keyb = table2.keyb

    inner join table3

        on table3.key = table1.key

        and table3.date = table1.date

 

 

2 Comments
Alteryx
Alteryx

Thanks for reporting this. The word wrap issue is an easy fix, the second part will be a little more difficult.

16 - Nebula
16 - Nebula

Thank you @JPoz  - I'll split the indenting one into a different idea here: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Changes-to-indenting-in-SQL-Query-Window/idi...