Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Inline Table...

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

10 Replies
thomaswrieck
Partner
Partner

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

Not applicable
Author

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

MK_QSL
MVP
MVP

Provide sample data...

bill_markham
Champion III
Champion III

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

Not applicable
Author

Hi Bill,

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

bill_markham
Champion III
Champion III

bill_markham
Champion III
Champion III

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

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