How touse excel file for multiple variablesPlshelp
Please help me the below mentioned query asap.
Step 1: Select "Variable...Create" from the top menu of the Script Modeler. Enter the variable name, scope, type and order. Set the Value Source to "Database". Select Next.
Step 2: Change the Data Source value to "Excel Files" and select Next. Select your Excel file using the dialog box that now appears.
Step 3: Select the radio button for "Query" and enter a query in the window that will select the correct column from your Excel workbook.
For example "Select StateCode from ?Sheet1$" and click on Next button.
Please refer the snapshot attached.
Kindly help me because we are using 8 variables to parameterise.
Re: How touse excel file for multiple variablesPlshelp
Please any one can tell me how to solve this problem