This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
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?