PLS GIVE ME EXPLINATION ABOUT THIS EXPRESSION?

[#1]

PLS GIVE ME EXPLINATION ABOUT THIS EXPRESSION?

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

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

[jagan]

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.