Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
please post your complete load statement.
thanks
regards
Marco