Mapping or join

[bharatkishore]

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

[bharatkishore]

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.

[bharatkishore]

Hi Gerold,

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

[qlik4asif]

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

Then store the table in QVD

[bharatkishore]

Can  you please help me how can i achieve it.

Because that is what i am not sure..

[kakani87]

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,

     Category

FROM

(qvd) Where Calendar_Month_Code ='201701' and  Sales_Organization='US93';

Temp:

Mapping

load

Key

,Category

Resident Category;

Overview:

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

     Sales_Organization,

     Material_Code,

     SWO_Code,

     Equipment_Code,

     [mat con fix cur],

     applymap('Temp',Key) as Category

FROM

(qvd) Where Calendar_Month_Code ='201701' and  Sales_Organization='US93';

STORE Overview into [..\QVD\Overview.qvd](qvd);

drop table Overview; 

[qlik4asif]

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

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

[qlik4asif]

PFA

[bharatkishore]

Hi,

I am getting error as Key field not found..

[bharatkishore]

Hi,

Thanks i have tried your code but category field is missing

[kakani87]

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

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