Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

The purpose of Evaluate Expression Tool in IWS is to provide users the ability to preview the functions output without having to actually execute the solution.

To demonstrate this feature, we will walk through the creation of a generic transform solution using the Transform and Generic Load template.

From New Solution, select Templates, select the Transform and Generic Load and enter a unique name for the solution. Click OK.
New Solution window - Transform and Generic load  
In this example, the Source is RAW format and the Destination is Delimited File (by comma separator). Click Apply.
Task Format window
The worksheet describing the t-stream is created.
Worksheet with T stream example
If your worksheet view differs from the above screenshot, you can access this view by double clicking the translator file in the solution explorer:
Solution Explorer drop-down menu
Choose a field using functions and click the  icon:
Evaluate Expression tool
This will bring up the Evaluate expression pop-up window:
Evaluate expression window
You can now enter your functions manually or double-click their names in the bottom-right list of functions to create required expression.
The top-right box contains variables used in current solution which can be also added to the expression via double click. The window also contains several tooltips to guide you.
 
When the expression is composed, click the  button to preview:

Evaluate Expression window
When you are satisfied with the result, click OK to save changes to the field.

You may also choose to copy the expression for further use elsewhere.


  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.