What is it with Alteryx SQL Queries and Enter Keys?

Question

Too often, when I do queries on MySQL (Workbench) and paste them to Alteryx (Input Data or Connect In-DB), the same query usually generates an error.

There are times when Alteryx just inserts a space between !=. In many others, it just flags enter keys as errors and I'm forced to remove them manually. It gets VERY tedious when the queries are complex.

It's driving me nuts.

RonGatmaitan · Answer

Hi, @PeterA1. Sorry for the late reply. Email didn't send notification. Other than that, it was hard to recreate.

It was much like the pi ("π") symbol being inserted, prompting Alteryx to generate errors. Also, it could have been the <Tab> character I place to make my MySQL statements more readable.

I will send it here as soon as it occurs again.

The "!=" errors are more tolerable as they are easier to find.

PeterA1 · Answer

Hi @RonGatmaitan can you show an example of what you mean? So are enter keys being interpreted as 
 newline characters? Or if the query such as "!=" falls at the end of the line the ! and = get split?

Also, to replace en masse on newer versions of Alteryx you can use the find and replace function.

Best,

Peter