Delete or exclude rows from a batch macro output

Meena

Hi,

I have output from a batch macro which populates results based on certain business rules.

Since the same name, value can pass 1 business rule and fail another - The macro result output will have more than 1 result for each record, name combination based on the number of business rules being processed by the macro.

I've attached the expected output from the macro.

The rows highlighted in yellow should be excluded or deleted based on a Record ID, Name combination.

That is for a record ID, Name combination if there are more than 1 row then the row with 'Valid' in result should be deleted before proceeding to the next step in workflow.

However if there are more than 1 rows with 'Valid' for a record Id, name then 1 of it should be included (like Record Id 3, Merchant Name).

Please suggest how this can be done.

Thanks

Delete rows from macro output.xlsx

danilang

Hi @Meena 

This should provide you with what you're looking for

The filter split the records based on OutputResult.  The false records get a unique applied to remove all the duplicate "Is Valid" rows.  This rest are joined to the True records from the filter, but here the join is used to exclude and rows/names that are covered by the top True path so we take R output of the Join.  Union these with -1 records, sort by record ID and you're left with

   

Dan

DeleteRows.yxzp