Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
transalp89
Contributor
Contributor

ApplyMap issue

New in Qliksense after several year with Qlikview...

A simple applymap which work in QV don't work in QS Why

TOTRANSLATE:

Mapping LOAD * INLINE [
FactCode, FACTNAME
01, A

04, B

A9,C

B0, D
];

 

When I apply, it works properly for A9 & BO but not for 01, 04 Why ?

I use

applymap('TOTRANSLATE',Code) as NewCode;

 

Thansk for, your help, not so easy to go frm qlikview to Qliksense !

 

 

Labels (1)
2 Replies
dplr-rn
Partner - Master III
Partner - Master III

As far as i know there is not difference in Mapping load or applymap between qlikview and sense. i tried to simulate with simple example below and it works.

I suggest you look at the data in your Code column.

TOTRANSLATE:
Mapping LOAD * INLINE [
FactCode, FACTNAME
01, A
04, B
A9,C
B0, D
];

load *,
applymap('TOTRANSLATE',Code) as NewCode;
load * inline [
Code
01
04
A9
B0
];

Capture.jpg

 

Ivan_Bozov
Luminary
Luminary

Most probably the data in your Code field has different formatting, e.g. text or half text and half numbers or 01 might be loaded as 1, etc. Check that field.

vizmind.eu