New nested statement

kodonnellLT
kodonnellLT
in Magic ETL

I Need to create this nested statement in the Domo Dataflow but I keep getting a syntax error.


I tried doing it a few ways and both are creating errors

SELECT 

CASE 

WHEN "Status__c" in ('Booked') AND > 111 THEN 'TIER 4'

ELSE 'TIER 1'

 END

FROM "sfdc_travel_raw"

or this query


SELECT *,

SUM(case WHEN "Status__c" = 'Booked' > 111 then 'tier 4' else 'tier 1 end)

FROM "sfdc_travel_raw"

Comments

  • RobSomers
    RobSomers Coach

    @kodonnellLT What field is supposed to be greater than 111? You are missing that field, so it should be:

    case when `Status_c` = 'Booked' and `Field` > 111 then 'Tier 4' else 'Tier 1' end

    Your last example won't work because you're doing an aggregation without any grouping.

    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**

  • MichelleH
    MichelleH Coach
    edited February 21

    @kodonnellLT Both of these queries are returning syntax errors because you need to specify which field needs to be greater than 111 in your case statement. In other words, it should look something like this:

    CASE 
WHEN "Status_c" in ('Booked') and "FieldName" > 111 then 'TIER 4'
ELSE 'TIER 1'
END

Categories