Inline Table...

[#1]

...Hi all,

I'm trying to left join from an inline table, can this be done?? Here's the script I'm using;

NWRAllPensions:

LOAD productgroup2,

     total_cust_fum_grp,
     years_to_srd_band,
     Exit_charges,
     Partial_vesting,
     dob
FROM
[\\sdorsf003\ukc\Commercial\QlikView Imports\EveMorgan\DataImports\allpens_custs_q32014.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

left Join(NWRAllPensions)
load * Inline[
total_cust_fum_grp, SortId,
100k+,6
between 10k and 30k,5
between 50k and 100k,4
between 30k and 50k,3
Less than 10k,2
Unknown,1]

;

I'm trying to load a sort id against the field total_cust_fum_grp

[francoiscave]

Hi Thomas,

Use always the third parameter in the ApplyMap() function. It wil be useful as default expression.

applymap('mapname', expr [ , defaultexpr ] )

François