Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ioannagr
Creator III
Creator III

same applymap() returns results in one table but not in another??

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???

2 Replies
Taoufiq_Zarra

@ioannagr  can you share a sample data ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
ioannagr
Creator III
Creator III
Author

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