Manipulate User Inputted String with Single Quotes

Question

Hello,

I'm trying to build part of a workflow where a user input updates a SQL query. I basically want to allow users to enter a string of GL Account Numbers like:  10001,10002,10003  and have Alteryx convert it to  '10001','10002','10003'  at which point I can use the Dynamic Input to update the Where clause with this string. But I'm actually struggling to just get the quotes around the account numbers (which you would think would be the easiest part). The attached workflow is dropping the end of the string like in the picture below. Could someone please tell me what I'm doing wrong?

Thank you!

danilang · Accepted Answer

Hi @AW25

From the image you attached it looks like your workflow is truncating the string somewhere.  This is probably caused by the field GLAAccounts and GLAAccounts2 being defined as string(17).  "10001,10002,10003" has 17 chars.  Adding quotes into the middle of the string makes it longer which will cause Alteryx to silently drop the trailing characters that end up outside the bounds.  Put a Select tool early in your workflow to increase the length of these fields to 30, which will allow you to add leading and trailing quotes to each account number.

Dan