Alteryx Designer Desktop Discussions

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

Show Row Numbers in SQL Editor in Input Data Tool

gkochner
5 - Atom

Hello! I am wondering if it is possible to show row numbers in the SQL Editor in the Input Data tool, similar to what can be seen in Toad Data Point or SSMS. Being able to see which line of code is referenced when getting an error would be very helpful for myself and other members of my team.

 

 

Alteryx SQL Editor.pngToad SQL Editor.png

1 REPLY 1
TimN
13 - Pulsar

I don't think it's available in Alteryx.  You can develop the SQL in Toad and then paste into Alteryx.  It usually works without having to tweak.  Just remove ending ";" is one thing I've learned.

Labels