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

[thomaswrieck]

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

[#3]

That's what I thought, I can't see where I'm going wrong!

[MK_QSL]

Provide sample data...

[Anonymous]

Personally I would do a Mapping Load / ApplyMap instead of a Left Join.

[#6]

Hi Bill,

Do you know how the syntax would look for this option?

[Anonymous]

Mapping … and not the geographical kind

[Anonymous]

Don't join - use Applymap instead

[its_anandrjs]

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

[thomaswrieck]

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