topic Re: Mapping or join in QlikView

Mapping or join

bharatkishore — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have two tables.

In one table i have A,B,C,D.....K

In second table i have A,B,C,D,L.

Now i need to use combination of A,b,C,D(from 1st table if i don't use A,B,C,D from second table also fine) to get the value for L which is in second table.

Now for this what i need to do join or link the tables or Mapping.. I am not sure.

Can you please help me on this.

Thanks,

Bharat

Re: Mapping or join

gerry_hdm — Fri, 23 Feb 2018 06:54:05 GMT

have you a example . what is the Output ?

Re: Mapping or join

qlik4asif — Fri, 23 Feb 2018 07:02:41 GMT

You Can create composite key for Fields A,B,C,D in both tables

Now two tables will be connected with Composite key,

Dont forget to use autonumber after creating Composite key for better performance.

Re: Mapping or join

bharani8 — Fri, 23 Feb 2018 07:09:08 GMT

Below link gives u the required info..

how to create composite key

Re: Mapping or join

bharatkishore — Fri, 23 Feb 2018 07:14:40 GMT

Hi Asif,

I created a composite key now do i need to use left join and give auto number in second table.

can u please tell me how to do it.

Re: Mapping or join

bharani8 — Fri, 23 Feb 2018 07:17:49 GMT

Chk this link.. U will get clear idea...

After u create the composite key, both the tables gets joined with the composite key.. No Joins required separatly..

how to create composite key

Re: Mapping or join

qlik4asif — Fri, 23 Feb 2018 07:21:29 GMT

Tab1:

Load

Autonumber(A&B&C&D) as %key,

...

From ........file;

Tab2:

Load

Autonumber(A&B&C&D) as %key,

From ........file;

Now the Both tables will automatically get connected,

You can see in Table viewer

Re: Mapping or join

bharatkishore — Fri, 23 Feb 2018 07:24:04 GMT

Please find the attached app.

Now can you tell me how can i store this into qvd.

Re: Mapping or join

bharatkishore — Fri, 23 Feb 2018 07:25:30 GMT

Hi Asif,

I have tried your method.

Can you please tell me how can i store this into qvd.. PFA app.

Re: Mapping or join

qlik4asif — Fri, 23 Feb 2018 07:29:27 GMT

Store Tablename into Path.qvd(qvd);

Tablename - which table you want to store in QVD

Path - Loaction to store QVD

Re: Mapping or join

bharatkishore — Fri, 23 Feb 2018 07:32:36 GMT

I have two tables now. so if i store into qvd only one table will get stored into qvd.

I want after linking the two tables to be created as a qvd. .which includes both the tables data.

Re: Mapping or join

bharatkishore — Fri, 23 Feb 2018 07:34:34 GMT

Hi Gerold,

Can you please find the attached app and i need to store the two tables data into a qvd .

Re: Mapping or join

qlik4asif — Fri, 23 Feb 2018 07:37:40 GMT

Then you need to make it as a single table by using Mapping

Then store the table in QVD

Re: Mapping or join

bharatkishore — Fri, 23 Feb 2018 07:38:55 GMT

Can you please help me how can i achieve it.

Because that is what i am not sure..

Re: Mapping or join

kakani87 — Fri, 23 Feb 2018 09:46:50 GMT

This may be helpful??

Category:

LOAD Calendar_Month_Code &'|'& Sales_Organization &'|'& Material_Code &'|'& SWO_Code &'|'& Equipment_Code as Key,

//Calendar_Month_Code,

// Sales_Organization,

// Material_Code,

// SWO_Code,

// Equipment_Code,

Re: Mapping or join

qlik4asif — Fri, 23 Feb 2018 09:49:27 GMT

I have included code as per ur requirement in a new tab

Comment the first tab(ur code) and try to run it

Re: Mapping or join

qlik4asif — Fri, 23 Feb 2018 09:51:08 GMT

PFA

Re: Mapping or join

bharatkishore — Fri, 23 Feb 2018 10:03:43 GMT

Hi,

I am getting error as Key field not found..

Re: Mapping or join

bharatkishore — Fri, 23 Feb 2018 10:04:50 GMT

Hi,

Thanks i have tried your code but category field is missing

Re: Mapping or join

kakani87 — Fri, 23 Feb 2018 10:14:48 GMT

Data fields are same in the post and dashboard rite??

check with Asif's post showing category in that sample posted.