Automations Block

Merge Sheets

This individual automation is built to merge two sheets based on the conditions and get the final output.
Merging two sheets is a complicated task if just done on the excel or any other spreadsheet tool. This automation block just simplifies it.

Requirements:

Maximum size allowed for each file is 5 MB

Upload your sheets for comparison

(allowed file formats .csv only )

File 1

File 2

Select the way to join the datasets

INNER JOIN:
Gives records that have matching values in both datasets

LEFT JOIN:
Gives all records from the left dataset, and the matched records from the right dataset

RIGHT JOIN:
Gives all records from the right dataset, and the matched records from the left dataset

FULL/OUTER JOIN:
Gives all records when there is a match in either left or right dataset

Select the columns using which we can match the rows between the two files

Select Columns from File 1

Select Columns from File 2