SQL CASE Statement

[wallacedavidl]

Hey Team -

I've been using nested IF statements to build stats. Is there a way for me to use a SQL CASE statement? And if so, can you please provide an example?

Thanks, David

[Flag_Hippo]

This post and this post have examples.

[wallacedavidl]

Thanks. The first article has a great complex example. I need to run some tests. Thanks again. I think you can close this one out;

[wallacedavidl]

i'm successfully using CASE statements that return Integers such as the following:

SUM(CASE
WHEN
f_good
THEN 1
WHEN
f_bad
THEN 2
WHEN
f_ugly
THEN 3
ELSE 0 END)

I'm having an issue when I want to return a text string:

SUM(CASE
WHEN
f_good
THEN 'good'
WHEN
f_bad
THEN 'bad'
WHEN
f_ugly
THEN 'ugly'
ELSE '-' END)

OR...


SUM(CASE
WHEN
f_good
THEN format('good')
WHEN
f_bad
THEN format('bad')
WHEN
f_ugly
THEN format('ugly')
ELSE format('-') END)

What am I doing wrong?

Thanks,
David

[Flag_Hippo]

What exactly are you trying to achieve here as an end result and why are you using SUM? What is f_good, f_bad and f_ugly? Without context, specific details and expressions it's difficult to give relevant advice. Presumably you are trying to group data with a custom statistic in a player report by certain board textures? For that you can build a custom column for the groupings you want and then you can do the text formatting in the statistic itself. Look at the built-in statistic 'Flop Bet Size' for an example of this type of statistic.

[wallacedavidl]

Hey, Team -

What I want to achieve is to have the THEN return a Text String.

[Flag_Hippo]

That doesn't answer my questions but depending on what you want as an end result in PokerTracker 4 you can format the text output in the statistic and not the column. Presumably you are trying to group data with a custom statistic in a player report by certain board textures? For that you can build a custom column for the groupings you want and then you can do the text formatting in the statistic itself. Look at the built-in statistic 'Flop Bet Size' for an example of this type of statistic.

[wallacedavidl]

Hey, Team -

I understand you can use format ('Text String') in an IF statement as shown in the example you provided. But when I try and use format ('Text String') in a CASE statement within a Statistic, PT4 returns an error. Do you have an example of a CASE statement within a Statistic that returns a Text String in the same way that an IF statement does?

Thanks,
David

[Flag_Hippo]

No I don't have an example although I still don't know exactly what you are trying to achieve as an end result in PokerTracker 4. As I have been asking in previous posts are you trying to group data with a custom statistic in a player report by certain board textures? Or are you trying to do something else? Please provide more context and specific details about what you want this statistic to do in PokerTracker 4. Thank you.

[WhiteRider]

Hey, Team -

I understand you can use format ('Text String') in an IF statement as shown in the example you provided. But when I try and use format ('Text String') in a CASE statement within a Statistic, PT4 returns an error. Do you have an example of a CASE statement within a Statistic that returns a Text String in the same way that an IF statement does?

Thanks,
David

If you are still trying to use the "SUM" around your expression that will not work with strings. You cannot sum (add up) string values.