Dynamic Filter Help

Question

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

SourceStatusNewsDeclinedMusicApprovedNewsDeclinedNewsApprovedMusicDeclined

Desired output

SourceStatusNewsDeclinedMusicApprovedNewsDeclinedNewsApproved

Luke_C · Accepted Answer

Hi @sethuram85

Try this:

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

ChrisTX · Accepted Answer

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