how to concatenate two coulmn value into one

[Karim_Khan]

Hi Team,

how to concatenate two column value into one single column.

I wanted to create the logic in which if I select the Programme Name then it should pick the Program name along with its Entry Pages.

[ganeshreddy · Accepted solution]

Hi karim,

use new dimension like below

Load

[Programme Name],

[Entry Pages],

[Programme Name]&' '&[Entry Pages] as Combination,

.......

FROM ......;

use above combination field when its required as combination.

Regards,

Ganesh

[gautik92]

create a key

ProgrammeName &'|'&  EntryPages as  %Key

[Karim_Khan]

Hi,

    I wanted to get the sum of visits on the selection of current programme but its not working by applying below expression

=sum({$<[(v0) Program Name]={Combination}>}Visits)