hi
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
