join not working between excel and sql table

[Jesh19]

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.

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

[kakani87]

can you share some  sample data

[mayankraoka]

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]

Hi Mayank,

The value/format in my joining key is same.

Thanks & Regards,

Jesh

[mayankraoka]

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

Regards,

Mayank