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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Dynamic Input - Losing format on SQL query

Alteryx Certified Partner

Hi All,

 

Just had a quick yes or no kind of question.
A user was talking about having very large SQL queries in a dynamic input tool.


Every time she needs to make a change in that statement, and opens the workflow, all formatting has been lost.

Any spacing between lines has been lost and it makes it tricky to find where they left off.

 

Is there any way to hold the format of the query in the tool?

 

Thank you kindly!!

Jordan

Alteryx Certified Partner

Hi @JordyMicheal 


When you say the formatting is being lost do you mean within the SQL query defined in the Input Data Source Template within Dynamic Input?

 

I did a quick and unscientific test and line breaks seem to be retained in this query when saving and reopening the workflow.

 

The below is after closing the workflow and reopening it.

 

Screenshot 2019-05-14 at 21.18.58.png

Highlighted
Alteryx Certified Partner

Hi @jamielaird 

 

Odd enough it seems to be the box I've highlighted there.

If not checked, it wipes any formatting in the SQL Editor. Weird.....

 

2019-05-15.png

 

 

Labels