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