Output -

[suby]

Hi,

In my workflow i have three text input joined and at the end i have a formula  where I'm flagging 

IF [SUB CATEGORY STATUS] ='LIVE' THEN 'YES' ELSE 'NO' ENDIF 

Expecting two scenarios to be worked out

Scenario 1 =

if the user filters on TEST column = YES then i get two records which is not right since there is only one 

22_SUB CATEGORY ID  =M123 AND SUB CATEGORY STATUS = LIVE 

scenario 1 expected output.

Scenario 2-

Also I i want the two rows which is coming on the browse tool on a separate stream to do further calculation on PROD ID, DC & DSC.

Attached the sample flow.

Thanks

[Thableaus]

Hi @suby 

Could you be more specific on what you're trying to achieve? I confess I wasn't able to understand the desired output.

Cheers,