Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Manipulate User Inputted String with Single Quotes in Teradata

Highlighted

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.

 

Highlighted
Alteryx
Alteryx

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

 

Highlighted

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?

 

 

Highlighted

Hi echuong1,

 

Is there any other solution possible?

 

 

Highlighted
Alteryx
Alteryx

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!

Highlighted

Yup that works!  Thanks for your help on this

Labels