Add values to dimension

[coolguy123]

I have a data set and have added a value using inline load

temp:

load 

“car model”,

“car reg”,

year

from abc;

concatenate (temp)

load * inline [

‘“car model”

‘Super’

]

now my issue is the new model I added called Super is listed but won’t interact with any other data or fields 

when I select Super all charts/tables only show null

[Ksrinivasan]

hi,

yes nothing will appear while you have selected Super field because no data wrt. super in other fields.

as below

to overcome that you use applymap function in load script instead of concatenate (temp),

ksrinivasan

[Ksrinivasan]

hi,

you can try left join also

as given

car:
LOAD
"“car model”",
"“car reg”",
"year"
FROM /SSSS1.xlsx]
(ooxml, embedded labels, table is carr);

left join

LOAD * INLINE [

“car model”, Super

A, 100000
B, 90000
C, 80000

];

result will be 

it will show the value when you select Super

ksrinivasan