Filter Column using where condtion in column level in Snowflake

Question

I want to apply a column level filter like if there is an account of 30 then that value has to be taken. But I do not want it to apply this account filter to the whole table as I have few more columns with the same ask like this.

I want to filter it in the select statement column level not after the from table. Value in the select statement is the required column that is needed with filters on account and month columns.

For Ex. (Select value where account =30 and month = 'jan' as new_value from table)

I do not want (select value from table where account = 30 and month = 'jan')

Please let me know can this be done using any functions in Snowflake?

what do you want selected if the account is <> 30? – Kurt Feb 10 '23 at 17:09 — Kurt, Feb 10 '23 at 17:09
how many values aha account 30 provide data please – nbk Feb 10 '23 at 17:12 — nbk, Feb 10 '23 at 17:12

Kurt · Answer 1 · 2023-02-10T17:23:26.810

0

Typically this would be done as a CASE statement. Something like this:

SELECT
    CASE
        WHEN t.account = 30 and t.month = 'Jan' THEN t.value
        WHEN t.account = 30 and t.month = 'Feb' THEN t.othervalue
        ...
        ELSE t.somedefaultvalue --or NULL or whatever
    END as value
FROM
    table t

CASE is like a If/then/else statement in other languages.

edited Feb 10 '23 at 17:23

answered Feb 10 '23 at 17:13

Kurt

1,708
1
3
11

What if I have two filters needed.. like account = 30 and month = jan?? – Anonymous Feb 10 '23 at 17:18
I get all Nulls when I do this – Anonymous Feb 13 '23 at 12:43
@Anonymous then the values are not matching correctly. Please add a sample of your table data to the question so we can see what we're dealing with – Kurt Feb 13 '23 at 15:34

Filter Column using where condtion in column level in Snowflake

1 Answers1