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]

Can you provide sample input data and expected output?  The requirements are not clear at all, at least to me.

Chris

[MoinShaikBasha]

Attaching the sample file. HOpe this helps.

[MoinShaikBasha]

Attached the sample file below.

[Raj]

Made for similar scenario this will help you build your logic. @MoinShaikBasha see if this help.

[ChrisTX · Accepted solution]

Try your 3 scenarios against the attached workflow

 

Chris

[CoG]

Here is another sample that is slightly simpler and has the added benefit of being much more dynamic: