PLS GIVE ME EXPLINATION ABOUT THIS EXPRESSION?

Tue, 24 Jun 2014 08:07:18 GMT

concat(if(len(Expression),chr(39) & Dimension & chr(39)),',',Sequence) as AllDimensions

,concat(if(len(Expression),Expression),',',Sequence) as AllExpressions

Re: PLS GIVE ME EXPLINATION ABOUT THIS EXPRESSION?

jagan — Tue, 24 Jun 2014 08:53:22 GMT

Hi Manoj,

Check this

Syntax for Concat:

concat ([ distinct ] expression [, delimiter [, sort-weight]])

concat(if(len(Expression),chr(39) & Dimension & chr(39)),',',Sequence)

for the above script you will get the Dimension values sorrounded by single quotes, and each value separated by comma.

For example if you have

Dimension, Sequence, Expression

One, 1, 100

Three, 3, 20

Two, 2,

For the expression you will get

'One','Two'

Regards,

Jagan.