I have a spreadsheet with two worksheets (sheet1 and sheet2). I have a second spreadsheet which lists all the records that need to be removed from both worksheets, the new edited output will be in sheet1_v2 and sheet2_v2.
How would you advise I move forward with this?
Many thanks
Hi @saqibamin, supposing that every record from the sheet1/sheet2 has unique ID as an attribute, and the second spreadsheet contains ID values of records to be removed.
A possible way is, use a FeatureMerger to merge the records from the second spreadsheet to the records from the sheet1/sheet2 using the ID as join key, write the unmerged records into the sheet1_v2/sheet2_v2.
The DatabaseJoiner or the FeatureJoiner could be used instead of the FeatureMerger.