<< Click to Display Table of Contents >> Navigation:  Nodes > Tasks > Spreadsheets > Inner join CSV

 

Purpose

 

This node permits to inner-join two .csv spreadsheet files, that is, combine records from two tables whenever there are matching values in a field common to both tables (a same field appearing in any row but with the same column header).  

Once the rows are filtered by matching fields, the columns of the second csv are added to the first one, thus providing the complete metadata from both tables for the matching elements.

This node is written on Python, and the source code is provided for user convenience (Code property).

Standard properties

 

Object Name

Color

Bypass

Lock

 

Inputs

 

csv: input csv file, which will be appended with new columns from a second csv file (the one specified in the CSV file path property).

 

 

Outputs

 

csv: New csv file resulting from the inner-join recombination.

 

 

Python standard properties

code

Schema name

 

NOTE: An introduction to all the Python tools in Mistika Workflows is available in the Python scripting tools section.

 

Node Specific Properties

 

CSV Delimiter: The column delimiter used in the CSV files. Options are:

- Auto: Detected automatically from the file content (default).

- Tab: Tab-separated values.

- Comma: Comma-separated values.

- Semicolon: Semicolon-separated values.

 

CSV File Path: The second csv table (which will be acting as dictionary).

 

Input first: Specify wich csv is taken first, then appended with the columns of the second csv. If active, the columns of the csv file given by the input connector are placed first, and then the ones from the CSV File Path.

 

Dst. File Path: Where to store to new csv file after the inner-join operation.

 

 

 

 

 

 

 

 

 

Developer reference (Python - InnerJoinCSV.[Property ID], API Rest - node/InnerJoinCSV/property/[Property ID])