Data joining in QlikView

[Anonymous]

Hi All

I am facing data joining issue.Initially my data has two tables as below:

I used applymap for Region and country columns so as to get full names,but still I am getting table as above.I need something which looks like:

Please help me.....

[sdmech81]

Hi,  please use this key ..SiteID&'_'&AccountNumber as KEY and join the tables..

Those rows might be missing bcs those aact no might be missing in first table..

We need to understand you data granularity.. Unfortunately I am not in front of system.. Please go through that thread to understand how joins work there are even examples as well..

[vinieme12]

please post sample data in excel

[sangeess21]

Check the attached file. Hope it helps you!

[Anonymous]

Hi Vineeth

Posted sample data.

If I have multiple account number and billing number rows I am not getting them in pivot table but they are showing connected when I take a list box

[Anonymous]

Hi Sangeetha/Imad

I am using QlikView Personal Edition.I am not able to open your files.Thank you

[vinieme12 · Accepted solution]

FACT:

LOAD Region,

     Country,

     City,

     SiteID,

     AccountNumber,

     Model,

     Desc,

     Amount

FROM

(ooxml, embedded labels, table is Sheet1);

JOIN

LOAD

     AccountNumber,

     BillingNum,

     Sale

FROM

(ooxml, embedded labels, table is Sheet2);

[Anonymous]

tried the same Vineeth,but still getting null value in sale row for account number having multiple rows

[vinieme12]

can you post your app? what expression are you trying?

[Anonymous]

joined two tables and took a pivot table with fields Region,Country,City,Site ID,Account Number,Billing Number,

Model,Desc,Amount,Sale

in expression  tab I am just using Amount and Sale directly

[vinieme12]

I'm not able to replicate the problem, please post your app

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample