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.
Solved! Go to Solution.
Can you provide sample input data and expected output? The requirements are not clear at all, at least to me.
Chris
Attached the sample file below.
Made for similar scenario this will help you build your logic. @MoinShaikBasha see if this help.