topic Re: Inline Table... in QlikView

Inline Table...

Fri, 12 Dec 2014 11:54:14 GMT

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

Re: Inline Table...

thomaswrieck — Fri, 12 Dec 2014 11:59:30 GMT

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

Re: Inline Table...

Fri, 12 Dec 2014 12:01:12 GMT

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

Re: Inline Table...

MK_QSL — Fri, 12 Dec 2014 12:02:36 GMT

Provide sample data...

Re: Inline Table...

Anonymous — Fri, 12 Dec 2014 12:05:43 GMT

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

Re: Inline Table...

Fri, 12 Dec 2014 12:11:52 GMT

Hi Bill,

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

Re: Inline Table...

Anonymous — Fri, 12 Dec 2014 12:24:46 GMT

Mapping … and not the geographical kind

Re: Inline Table...

Anonymous — Fri, 12 Dec 2014 12:25:16 GMT

Don't join - use Applymap instead

Re: Inline Table...

its_anandrjs — Fri, 12 Dec 2014 12:29:48 GMT

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

Re: Inline Table...

thomaswrieck — Fri, 12 Dec 2014 12:30:47 GMT

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

Re: Inline Table...

francoiscave — Fri, 12 Dec 2014 13:18:49 GMT

Hi Thomas,

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

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

François