Append variable into dimension

[ramanannad]

Hi Experts,

Have an inquiry on how do we append a value from a front-end variable into a loaded field from data source ?

Visualization :

Source table(excel file):

Name	Sales
MrA	100
MrB	101
MrC	102

frontend Variable(achieved thru an input box extension):

Variable	Value
vTstname	MrD

Expected Output :

Name	Sales
MrA	100
MrB	101
MrC	102
MrD	-

Or just ignoring the measure, we just need :

Name
MrA
MrB
MrC
MrD

Hope you guys any an idea about this, cheers

Ram

[Anil_Babu_Samineni]

Try this?

LOAD * Inline [

Name, Sales

MrA, 100

MrB, 101

MrC, 102

];

Concatenate

LOAD * Inline [

Name

'$(Variable)'

];

[effinty2112]

Hi Ramanan,

Try this calculated dimension

=Name & if(isnull(Name),vTstname)

Cheers

Andrew