Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, something very weird is happening, that hasn't happened before.
My mapping load is this:
MapAnswer:
Mapping load * inline [
answer, answer1
0,'no'
1,'yes'
];
and then
applymap('MapAnswer',answer,'-') as answers.
This applymap i have applied in another table that uses the field answer and it returns correctly Yes,No,- .
However in another table all it returns is dashes (-) which is wrong as i look at the data. Note that the answer fields are integer (0,1) in both tables.
Help???
@ioannagr can you share a sample data ?
i don't know how to. @Taoufiq_Zarra
But could you tell me, i suspect that the problem is that in another qvd i too have a field called
applymap('MapAnswer',answer,'-')&concat(something) as answers
Could it be the reason that applymap('MapAnswer',answer,'-') as answers shows me only dashes in the table of interest?
Im confused though, as qvd creators drop tables, so no synthetic keys happen