Input Tool - loosing SQL structure/indentation

Question

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?

tskora · Answer

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.

geraldo · Answer

@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 · Answer

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?