Joining/Keeping after inner join

Tue, 06 Nov 2012 13:48:32 GMT

In one tab i did three join between three table (a,b,c).

LINK_TABLE:

load distinct
FactKey_Failure,
Serial_Number_Failure as Serial_Number,
Failure_date as Date_Calander
RESIDENT a ;

join

load distinct
FactKey_Jam,
Serial_Number_Paper_Jams as Serial_Number,
date_Jame as Date_Calander
RESIDENT b ;

join

load distinct
FACT_CUSTOMER_Key,
serial_Number_360 as Serial_Number,
FACT_CUSTOMER_date as Date_Calander
RESIDENT c;

In the next tab I load data from a differnt table (d).

CALENDAR:
LOAD "Date_Calander",
"Year_Num",
"Month_Num",
"Quarter_Num",
"Calander_Presenet_Date"
WHERE exists(Date_Calander,Date_Calander);

SQL
select distinct CONVERT(varchar(10),a.Date,103) as Date_Calander,
DATEPART(YEAR,a.Date) as Year_Num,
DATEPART(MONTH,a.Date) as Month_Num,
DATEPART(QUARTER,a.Date) as Quarter_Num,
LTRIM(RTRIM(convert(char,(DATEPART(MONTH,a.Date)))))+'-'+LTRIM(RTRIM(CONVERT(char,DATEPART(YEAR,a.Date)))) as Calander_Presenet_Date
FROM EPICPDW.dbo.Fiscal_Calendar a;

For some reason the d table did not appere, when i look in the Log File I saw that QV did a "Joining/Keeping" with the d table , why?

how do I avoid it ?

Thank you

Re: Joining/Keeping after inner join

fdelacal — Tue, 06 Nov 2012 13:54:05 GMT

CALENDAR:
noconcatenate LOAD...

hope it helps you

Re: Joining/Keeping after inner join

Tue, 06 Nov 2012 14:00:42 GMT

Thank you

i will try it

Although I do not understand why it is happening it is in a different Tabs

Re: Joining/Keeping after inner join

Wed, 07 Nov 2012 09:19:26 GMT

its not working still doing , Joining/Keeping

topic Re: Joining/Keeping after inner join in QlikView

Joining/Keeping after inner join

Re: Joining/Keeping after inner join

Re: Joining/Keeping after inner join

Re: Joining/Keeping after inner join