Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
I write script using apply map, but qlik show me the error sign . i completely confused
i loading script, excel and error message here
hope you can guide me
Hello!
try this
load
applymap('Map',Field) as A
, applymap('Map2',Field) as B
, applymap('Map3',Field) as C
, applymap('Map4',Field) as D
, applymap('Map5',Field) as E
,
applymap('Map3',Field) &'/'& applymap('Map4',Field) &'/'& applymap('Map5',Field) as JRealMonth
;
maybe the error is while the statements are in same load
you create your field and retrieve it in same load
use preload to define your field JRealMonth
Load *,
... as JRealMonth;
load
applymap.....
Hello!
try this
load
applymap('Map',Field) as A
, applymap('Map2',Field) as B
, applymap('Map3',Field) as C
, applymap('Map4',Field) as D
, applymap('Map5',Field) as E
,
applymap('Map3',Field) &'/'& applymap('Map4',Field) &'/'& applymap('Map5',Field) as JRealMonth
;
Thank you soooooooo much
Thanks for your help