topic join not working between excel and sql table in QlikView

join not working between excel and sql table

Jesh19 — Sun, 03 Jun 2018 17:49:27 GMT

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

Re: join not working between excel and sql table

kakani87 — Sun, 03 Jun 2018 18:03:05 GMT

can you share some sample data

Re: join not working between excel and sql table

mayankraoka — Sun, 03 Jun 2018 18:33:04 GMT

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>

Re: join not working between excel and sql table

Jesh19 — Mon, 04 Jun 2018 04:44:15 GMT

Hi Mayank,

The value/format in my joining key is same.

Thanks & Regards,

Jesh

Re: join not working between excel and sql table

mayankraoka — Mon, 04 Jun 2018 05:49:37 GMT

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

Regards,

Mayank