Expression help !!!

[ganeshreddy]

Hi All,

The following expression is not working.

if(CId_Count>1,concat(distinct ServiceType,',')&'Multiple',concat(distinct ServiceType,',')) as Service_String

can any one help.

Cheers,

Ganesh

[rwunderlich]

Is CId_Count part of your  GROUP BY clause? It needs to be or you will have to apply an aggregation to CId_Count.

-Rob

http://masterssummit.com

http://robwunderlich.com

[MarcoWedel]

please post your complete load statement.

thanks

regards

Marco