Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Manipulate User Inputted String with Single Quotes in Teradata

HeadBanger
8 - Asteroid

I'm trying to use a dynamic input where I'm changing a SKU list every time I run the workflow.  The idea is to have the SQL query update with this new set of SKUs that I've introduced in the workflow.  I first use a formula so it is in the correct Syntax for SQL to read the query.  Then use the Summarize tool to concatenate the result without the quotes at the end.

The problem is after running the workflow it seems SQL is adding Double Quotes instead of keeping my single quotes in the Query.

Hopefully the Pictures make sense of what i'm trying to do.  Let me know if there is a way around this.

 

5 REPLIES 5
echuong1
Alteryx Alumni (Retired)

Are you trying to replace a series of values or do you just want the user to be able to update depending on what SKU is specified? 

 

If it's the latter, you can use a text input and action tool to achieve this. Configure the action tool to replace the SKU specified in the where clause. The user would input the new SKU to be used in the text input.

 

echuong1_0-1581533772403.png

 

HeadBanger
8 - Asteroid

Hi,

 

I'm trying to have the SKU list update within the workflow.  I don't want the user to have to do anything if possible.  If you see my query in the attached picture, you can see that Teradata is unable to read the SKUs because it has added another quote so it reads "107513" instead of '107513'.  Is there a way around this without having to do a text input action tool?

 

 

HeadBanger
8 - Asteroid

Hi echuong1,

 

Is there any other solution possible?

 

 

echuong1
Alteryx Alumni (Retired)

Use the replace a specific string option instead of the where clause option. 

 

In text to replace, use SKU_List. The replacement field will be your concatenated SKUs with single quotes around each and a comma between. 

 

Let me know if that works!

HeadBanger
8 - Asteroid

Yup that works!  Thanks for your help on this 🙂

Labels