How to Concatinate the Variables ??

[vinnusea]

Can anyone tell me how to pass a varible value into a parameter so that i can insert that parameter into a column in Sql table

Issue:

Taking a Cube View as Source and it is having varibles V1,V2,V3,V4,V5 DEFINED and now i have Col1,Col2,Col3,Col4,Col5,Col6 in Target Table

I need to pass V3 | V4 |V5 |'Rate' (Concatinated) into Col 6

In Prolog i used

scol6input = V3|V4|V5|-|'Rate' ;

In Data Tab:

In Sql Statement :

I used scol6input Then its not trowing any error but the Col6 in Target table is having just "- Rate"
My 3 variables are not showing in the target????

How do i get it

Thanks for your time

[ajain86]

the prolog tab does not read in the datasource.

move this statement to the data tab:
scol6input = V3|V4|V5|-|'Rate' ;

[vinnusea]

Yes
Now Its Working good after moving to Data tab..

Thank you soo much