Hi,
I'm looking for a dynamically filtered output to filter below table with the following requirement.
All the Approved & Declined statuses should be part of Output for the source 'News', but, only Approved status row for the 'Music' (Do not want to see Declined status of Music), I've been trying with Filter & Formula tools but not able to get the desired output.
Input table
Source | Status |
News | Declined |
Music | Approved |
News | Declined |
News | Approved |
Music | Declined |
Desired output
Source | Status |
News | Declined |
Music | Approved |
News | Declined |
News | Approved |
Solved! Go to Solution.
Hi @sethuram85
Try this:
([Status] in ('Approved','Declined') and [Source] != 'Music')
or ([Status] != 'Declined' and [Source] ='Music')
Use a Filter tool, choose the button for Custom Filter with this formula:
IF [Source] = "News" THEN 1
ELSEIF [Source] = "Music" and [Status] = "Approved" THEN 1
ELSE 0
ENDIF
Note: 1 represents True, and will send a record out the T anchor. 0 represents False, and will send a record out the F anchor
Chris
Thank you so much! This has perfectly worked for me.