Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you share some sample data
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>
Hi Mayank,
The value/format in my joining key is same.
Thanks & Regards,
Jesh
ok,Can you please share qvw so that I can look into it?
Regards,
Mayank