Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Jesh19
Creator II
Creator II

join not working between excel and sql table

Hi All,


I'm having the below 2 tables, Dimsales coming from Excel and Facts_L1 coming from DB.

The association between the 2 tables is maintained using Sales_RepKey.


But, somehow the association doesn't seems to be proper. If I'm selecting some value on Excel field, it's not showing the proper associated value from DB.

I want both the fileds to be associated properly.


Join Error.png

I want the association in such a way that if i select Australia from Cluster(DB), it should associate to Australia in Dimsales_Cluster(Excel).



The script used is as follows:


DimSales:

LOAD    

     UPPER(DimSales_Date &'-'& DimSales_Person_Email) as Sales_RepKey,

     DimSales_Date,

     DimSales_Cluster,

     DimSales_Region,

     DimSales_Country,

     DimSales_Branch

FROM

(qvd);

Left Join (DimSales)

Facts_L1:

LOAD

Date,

Cluster,

Region,

Country,

Branch, 

UPPER(MonthName(Date)&'-'& Sales_Person_Email) as Sales_RepKey 

FROM

(qvd)

where Date >= '01/01/2015';

Could someone please do the needful.

Thanking in Advance.

Regards,

Jesh

4 Replies
kakani87
Specialist
Specialist

can you share some  sample data

mayankraoka
Specialist
Specialist

Can you check whether thw value /format in your joining key ia same or not ?

On Sun, Jun 3, 2018, 11:56 PM Jeshwanth Boragani <qcwebmaster@qlikview.com>

Jesh19
Creator II
Creator II
Author

Hi Mayank,

The value/format in my joining key is same.

Thanks & Regards,

Jesh

mayankraoka
Specialist
Specialist

ok,Can you please share qvw so that I can look into it?

Regards,

Mayank