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.
Need some assistance with a workflow. I have a list box in my workflow that allows user to pick the state and then using action tool connects to the dynamic input tool to modify the Where clause of an SQL query in filter the query by the state picked by the user from the pick list. I do not get any errors but no output either. I have there is values in the database related to the state I pick by however the workflow does not return anything.
Can someone please help me? I have attached some pictures of how my workflow is configured.
I was able to resolve this issue by adding a output tool to export the results into an excel file. I can see that the selections are passing through and giving me the results accordingly.However now I am running into another issue. I have multiple dynamic input tools each one running different SQL query. When I make my selections as run the app, it results into ODBC Teradata error # 3807 object Z114 does not exists. I don't have this object referenced anywhere in my query.