Compare output data to existing spreadsheet and append if it doesn't exist in spreadsheet

abovino

There may be a simple solution for this but it's not coming to me at the moment.

I need to compare the output data from my workflow to an existing spreadsheet.  If the row of data does not exist in that spreadsheet I need to append it.

For Example:

Here's my output data:

Item	Color	Size
Shirt	White	XS
Shirt	White	S
Shirt	White	M
Shirt	Red	L
Shirt	White	L
Shirt	White	XL

And Here's the data in my existing spreadsheet:

Item	Color	Size
Shirt	White	XS
Shirt	White	S
Shirt	White	M
Shirt	White	L
Shirt	White	XL

I need to append the row that does not exist in the spreadsheet to the end of the spreadsheet.  So my spreadsheet looks like this at the end:

Item	Color	Size
Shirt	White	XS
Shirt	White	S
Shirt	White	M
Shirt	White	L
Shirt	White	XL
Shirt	Red	L

Bob_Blackey

Hi,

You can just Join the output data and the data from the existing workflow by the three fields. Depending on how you connect to the Join either the L or R output will be the rows that are not in the Spreadsheet.

You can then write those records to the spreadsheet and use the "Append to Existing Sheet" option within the Output data tool.

Cheers,

Bob

Join.yxmd