Consider specific data based on the single column with multiple criteria's

MoinShaikBasha

HI,

I have  a below data where there is going to be 2 types of data flowing in and I would need only 1 set of data to pass through based on a condition.

Sample Data:

Field 1

Sub_Supplement

Sub_Supplement

Sub_Supplement

Sub

Sub

and the output should be if I have both the data Sub_Supplement and SUb then only Sub_Supplement should flow further and if there is only either one of them then that respective data should flow in.

Thanks in Advance.

ChrisTX

Try your 3 scenarios against the attached workflow

Chris

Consider specific data based on the single column with multiple criterias.yxmd