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.

 

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”. 

• 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”