Dynamic Filter Help

[sethuram85]

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

[Luke_C · Accepted solution]

Hi @sethuram85 

Try this: 

([Status] in ('Approved','Declined') and [Source] != 'Music')
or ([Status] != 'Declined' and [Source] ='Music')

 

[ChrisTX · Accepted solution]

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

[sethuram85]

Thank you so much! This has perfectly worked for me.