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.
Unless there's some detail I'm missing, it should be a pretty straight forward app. Just set up your output tool to where it needs to record to and be sure you set the "Output Options" correctly. Workflow attached.
Appropriate for the help, It works well and now I got the basics at least. That was for my sample workflow to pass the parameters from users.
Now in my actual workflow, there are total 3 sql tables (table A,B & C) and it has limited columns, am trying to create something in Drop list tool, that users can select the table from the Drop list tool and they can pass the values by select the table.
And, also trying to deal with NULL values, e.g. on my current workflow if I don't enter any value in any of the column, it inserting as NULL in sql table but I want like if the users not enter any value in the column, it should be blank in sql table.
I attached screenshot of my current workflow, Do you know how I can set the Drop list tool and run the analytic app.
I have a potential solution for the Null values, before you output you could use the data cleansing tool to put a space if it is a text field and a 0 if it is a number field.
I have provided an option that might work in that you bring all data into one text input, have a drop down list that would feed in to a variable and then filter out to where it needs to go, this should help get you started