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 need to use that data above and pass it on to another workflow - Process Products. In this workflow, the input data is a SQL Query and the Product Id values from above go as part of the IN clause. Here is how the query looks like -
select productid, name from products where productid in (120,123);
Here is what I have done so far. I replaced the 'Input Data' with 'Dynamic Input'. I pulled in 'Input Data' tool with column ProductId having 2 row values and connected to 'Dynamic Input' and having the 'Update Where Clause'. This works as a stand-alone. Now I don't know how to go about connecting my original data and looping through whole groups. I pursued through multiple articles on batch macros and iterative macros but it's very confusing and not the same use case that I have. Any help?
Unsure if i have understood your query perfectly but thought i would give it go and hopefully get you started in the right direction. If i am completely off track then can you provide a snap shot of your work flow or even a attached example and ill try to get it closer.
The workflow uses your example input an feeds it into a batch macro which concat the Product ID into the format of your where query. If you place the dynamic input where the comment box is this should allow you to pull data per grouping.
Again this might not be perfect but hopefully will get you started.