Modify SQL

[adamturnbull]

Hi All,

Not sure if i'm doing this the right way if or it's even possible.

There's 2 part to my workflow.

The first part works fine. It gets a list of account numbers from an excel file and concatenates them into a string.

The second part is where i'm stuck.

I'm connecting to relational database and have a SQL query written, but I want the string from the first part of the workflow to be added to the SQL query without me having to go in and manually update the query each time.

Is there a way for this to be automatically updated/modified?

The account numbers from the first part of the workflow will be different each time i run it so i need the SQL query to be updated each time.

[guptav_pfizer]

Hi Adam.

Are you trying to pass two different variables for the where or on SQL Server side you have a concatenated value?

My simple suggestion would be, if you have concatenated field, then using formula widget, create the combined value first.  Do not use the Group Widget to do concatenation.  This will have the output from your WF1 come back with multiple rows.

When you use the Dynamic Input widget, it will run the interaction with SQL Server one row at a time and display the results once it has run through all the rows coming out of WF1.

Hoping this is able to help.

Typically for the IN CLAUSE, all Databases have a limit and I am assuming when you are trying to send to concatenated string, it might be exceeding the limit.  For example, Oracle used to have 255 different value could be passed in the IN Clause.  Not sure if those old limits are still there or now have changed.