Universe with an excel datasource

[Former Member]

Hello,

I am trying to build a universe based on an excel datasource.

I need to create an object "Age braket" with this kind of synthax :

case when Age < 20 then "0-20" else "+20" end

But I don't find what to use instead of "case when" to be compatible with an excel datasource.

Can you help me please ?

Thanks a lot for all your help.

I hope someone would have the response.

Regards

Emi

[Former Member · Accepted solution]

Hi,

Try this syntax:

IIF (Age < 20, '0-20', '+20')

Regards,

Didier