How to use Execute External WorkspaceNode?

How to use Execute External WorkspaceNode?

book

Article ID: KB0074094

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.0.13.1,13.2,13.3.0

Description

Description: “Execute External Workspace” Node is a custom SVB node that allows users to reference/call functionality implemented in the external workspace by substituting selected inputs into it, executing external workspace and collecting selected result, which is then made available for the downstream processing and optionally outputting the results.
This node lets the user execute an external “template” workspace with substituted input data. This is especially used for data cleansing.  
The user needs to provide a path to the reference/external workspace which can be saved as a file on a local directory.

 

Issue/Introduction

This article shows an example of using Execute External Workspace Node?

Resolution

1. Let’s take a simple workspace as example external workspace, which merge the input “Data 1” and “Data 2” by a variable “key” in “Data 1” and “Data 2”. 
This example external workspace named as “Reference Wksp2.sdm” can be stored at local drive, for example, C:\Users\lliu5\Desktop\Reference Wksp2.sdm

2. Open a new workspace, load new datasets “New Data 1” and “New Data 2” which are to be used to subsititute the inputs in the external workspace in step 1, and load the “Execute External Workspace” node from “Node Broser | All”. 

3. Double Click on “Execute External Workspace” node, edit the parameters.
  • Workspace path: Specify the location of the external workspace to be called.
    • For example, C:\Users\lliu5\Desktop\Reference Wksp2.sdm
  • Inputs Assignment: Specify new inputs to substitute the inputs of the nodes in external workspace (Input Node names should be double quoted, semicolon “;” should be used as delimiter).
    • For example: “New Data 1” -> “Data 1”; “New Data 2” -> “Data 2”
  • Output Assignment: Specify outputs in external workspace to be collected in the main workspace for downstream analysis.
    • For example: “Merge Variables”

4. Run the “Execute External Workspace” node. 



The result node “Merge Variables” from executing the externally implemented workspace with the new input data, is added in the main workspace and this result file could be used for downstream analysis. 

 

 

 

Additional Information

Legacy Article ID: 185818