Statistica has a Merge Variables node with a "Like SQL" option.  How does this work?  

How the "Like SQL" option in Merge Variables node works.

Windows operating systems only. All versions and installation types.

The "Like SQL" option will remove duplicate variables in the output spreadsheet but will only keep the variable in the first input spreadsheet. 

 Note:  There is an order to the linked nodes or the "Root Node Execution Order".    This works like this: the first attached spreadsheet will take precedence as selected in the node. To determine the execution order, right-click on the empty space in a workspace and see the execution order:



Example
The exampe data used, but slightly modified, is in the End User guide here:  https://docs.tibco.com/pub/stat/14.0.0/doc/html/UsersGuide/GUID-95AE181F-C99B-4619-8FDC-C48E6217BE78.html

The attached workspace demonstrates how the spreadsheets are combined into one spreadsheet, with the variables merged.  With the "Like SQL" option, any duplicate variables are removed.  The variable that remains will be located in the one first attached to the Merge Variables Node.


1.  Below is the Cat Clinic Measurements (2000) and Cat Clinic Patient Info spreadsheets have been modified to include a exact duplicate of the variable named "Disease":


2.  Below we see the Merge Variable configuration is using "ID" and "Patient ID" without the "Like SQL" unchecked:


4.  The output is an additional variable with the same name but with an underscore at the end or "Disease_2":



This is as expected.  

5.  When using "Like SQL", the duplicate variable is removed:




 

https://support.tibco.com/s/article/How-to-merge-two-Statistica-Spreadsheets-in-Interactive-Mode