Looking for an equivalent to 'SELECT column_name WHERE IN' for beast mode.

user10466
user10466
in Magic ETL

Is there a Beast Mode equivalant for this SQL? Can Beast Mode even accomodate something like this?

 

select * from TABLE
where ResolvedBy in
(select distinct ResolvedBy from TABLE
where AssignmentGroup = 'IT Ops T1 Tickets'
and ResolvedBy != '')
and AssignmentGroup = 'IT Ops T1 Tickets'
order by ResolvedBy asc;

 

I know it can be done in a DataFlow, but I was told that Beast Mode can take pretty much any SQL scenarios. However, I have yet to figure out, or determine if the above is possible.

Comments

  • DataMaven
    DataMaven Contributor

    Would a series of CASE statements or nested CASE statements do the trick?

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • ST_-Superman-_
    ST_-Superman-_ Coach

    It looks like this could be done with 2 filters on the card

    1. 

    Place the `AssignmentGroup` field in the filters section and select 'IT Ops T1 Tickets'

     

    2.

    Place the `ResolvedBy` field in the filters and select the "not in" option and then the null box

     

    (if the second filter doesn't work then you may need to use a beastmode to highlight the null values)

    CASE WHEN `ResolvedBy` = '' THEN 'none' ELSE IFNULL(`ResolvedBy`,'none') END

    then you can place this beastmode in the filter and select not in "none"


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman

Categories