Input Tool - loosing SQL structure/indentation

[tskora]

Hi, when I'm copying SL to the input tool all seems to be fine and test connection is successful. After I close window all SQL loses it's structure - so no indentation and all code is put into a single line. Can anyone help with this? Why code structure is lost?

[geraldo]

@tskora 

What is the tool you are writing your sql to later copy to the Alteryx tool?

To make sure that end-of-line and tab characters are compatible

[tskora]

I am copying sql directly from Tableau custom SQL. How can I check combability or how to copy data to make sure that when I copy is compatible?

[geraldo]

@tskora 

It can happen that codes from web pages are copied when they go into the alteryx tool, it is structured but when it closes and opens again it is all unstructured.

I usually do the test copied to Notepad++ editor and see the result if the end of line and tab are being respected

[tskora]

I tried this but it did not worked. I seems that when I am using connection from server it breaks the code. What is important, Alteryx did trim on the all SQL code, that means if in where condition I had double space, it trimmed it and results were different than expected. When I switched tot he local connection, all works fine.