Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace:
bw:using_variables

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
bw:using_variables [2019/10/23 14:21]
akoehler Updated and changed the example for the UDV section 		bw:using_variables [2019/10/23 14:46] (current)
Line 154: Line 154:
 In the variables tool there is a **User Defined Variable ** of "UserVariable1" In the variables tool there is a **User Defined Variable ** of "UserVariable1"
  
-{{ :bw:variablestoolscreen.png?nolink |}}+{{ :bw:variablestoolscreen.png?569x110 |}}
  
 In the SQL tool step you can reference the **User Defined Variable** of "UserVariable1" by pressing [F4] in the SQL tool and navigating to the Variables option in the left menu and selecting the correct variable from the list of variables on the right menu. In the SQL tool step you can reference the **User Defined Variable** of "UserVariable1" by pressing [F4] in the SQL tool and navigating to the Variables option in the left menu and selecting the correct variable from the list of variables on the right menu.
Line 168: Line 168:
 ===== Step Variable Example ===== ===== Step Variable Example =====
  
-In the step marked “4” in the illustration above we are writing the output of the SQL step to a file.+In this example we are writing the output of the SQL step to a file.
  
-{{:bw:varimage9.png?482x384}}+Below is the workflow we are using for the example.
  
-In this step, we make use of both Step and User variable type.+{{ :bw:stepvariablesworkflow.png?nolink |}}
  
-To make the file name unique each time it is created, we use the “time stamp” user variable created by the VBScript step. As noted earlier, we can use either the output name from the VBScript step, or the value created in the Variables step. For this example, the value from the VBScript step is used.+Note the fields in the SQL statement that will be referenced later.
  
-{{:bw:varimage10.png?479x232}}+{{ :bw:stepvariablessql.png?482x384 |}} 
 + 
 +Next when going to the file writer step you will press [F4] and select the variables from the SQL step. 
 + 
 +{{  :bw:varimage11.png?483x298  }} 
 + 
 +You can see each step variable in the "Body" section of the FileWriter Tool. 
 + 
 +{{  :bw:varimage9.png?482x384  }}
  
-C:\Shared\Bizweaver\DataOut\Filewriter_VariablesTest_WorkFlow(VBScript).Get(TimeValue).txt 
  
-The values in the body section of the file (the actual data records) are step variables that come from the previous SQL Command step (3). 
  
-{{:bw:varimage11.png?483x298}} 
  
bw/using_variables.1571854865.txt.gz · Last modified: 2019/10/23 14:21 by akoehler

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki