topic Re: Key Logic in QlikView

Key Logic

Wed, 12 Mar 2014 10:19:05 GMT

Dear All,

Please tell me how to make Key between 2 tables having data as::

Table A:

Header 1	Header 2	Header 3
aa	01	200
bb	01	300
cc	06	300
dd	08	200

Table B:

Header 1	Header 2	Header 3
aa	06	800
bb, aa	01	300
cc, dd	02	700
dd	08	900

I have to make Key between Table A and Table B with Header 1 column...Plz show me the right way to do that...

Re: Key Logic

Wed, 12 Mar 2014 10:25:17 GMT

TableA:

load

* from TableA;

TableB:

load

subfield(Header1,',') as key

Header2 ,

Header3

from TableB;

Re: Key Logic

vikasmahajan — Wed, 12 Mar 2014 10:25:35 GMT

PFA sample application Hope this will definitely help you.

Vikas

Re: Key Logic

datanibbler — Wed, 12 Mar 2014 10:26:14 GMT

Hi Rahul,

that depends on which record from table_B you want to get joined/ linked to which record in table_A.

Generally, you can split the strings (pieces of text) in that header_field by using either of the string functions

- LEFT()

- RIGHT

- SPLITFIELD() (might be best if you know that your separator is always a ',')

=> Load the result as a new field which has to have the same name as the field_to_link_to in the other table - QlikView automatically links fields that have the same name.

HTH

Best regards,

DataNibbler

Re: Key Logic

er_mohit — Wed, 12 Mar 2014 10:30:24 GMT

Table1:

load [Header 1] as Key,[Header 2], [Header 3] from table1;

Table2:

load

subfield(Header,',') as Key,

[Header 2],[Header 3] from table 2;