Skip to main content
Join two CSVs
Wrk Product avatar
Written by Wrk Product
Updated over 3 months ago

Join two CSVs into a single CSV. Please refer to the documentation for more details on configuration.

Application

  • CSV

Inputs (what you have)

Name

Description

Data Type

Required?

Example

Left CSV

CSV to act as the primary table in the join

File

Yes

Right CSV

CSV to join onto the right of the main CSV

File

Yes

Left CSV join columns

A JSON array of the columns in the “Left CSV” that you are looking to join by. Example: [“Col1”]

Text (Long)

Yes

[“Col1”]

Right CSV join columns

A JSON array of the columns in the “Right CSV” that you are looking to join by. Example: [“Col1”]

Text (Long)

Yes

[“Col1”]

Join type

Method to join the two CSVs. Default is inner. Please see documentation for more details

Text (Short)

No

Inner

Left CSV separator

The character used to separate columns in the left CSV. Will default to ,

Text (Short)

No

,

Left CSV quote character

The characters used to indicate a string in the left CSV. Will default to “

Text (Short)

No

Right CSV separator

The character used to separate columns in the right CSV. Will default to ,

Text (Short)

No

,

Right CSV quote character

The characters used to indicate a string in the right CSV. Will default to “

Text (Short)

No

Outputs (what you get)

Name

Description

Data Type

Required?

Example

Joined CSV

Joined CSV

File

No

Outcomes

Name

Description

Success

This status is selected if the job has successfully completed.

Requirements

  • N/A

Did this answer your question?