Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
...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
Hi,
should work as soon as you name the join fields the same name ...
right now it will join both tables using total_cust_fum_grp from both tables ..
Regards
Thomas
That's what I thought, I can't see where I'm going wrong!
Provide sample data...
Personally I would do a Mapping Load / ApplyMap instead of a Left Join.
Hi Bill,
Do you know how the syntax would look for this option?
For mapping try this ways use Apply Map
MapTab:
Mapping 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];
LOAD productgroup2,
total_cust_fum_grp,
ApplyMap('MapTab',total_cust_fum_grp) as SortId,
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);
Regards
Anand
maybe content is not matching of the fields you would like to use for the join ... maybe leading or trailing blanks ...
then i think the applymap would not work as well ..