6 Replies Latest reply: Mar 6, 2018 6:37 AM by Sébastien Fatoux RSS

    Table not found

    Stéphanie EUSEBE

      Bonjour,

       

      Je ne comprends pas pourquoi j'obtiens le message d'erreur suivant "Table Suivi not found". Pouvez-vous m'aider ?

       

      Mon script est le suivant :

       

      [suivi]:

      LOAD

      [Num_Dossier],

      [Num_Sinistre],

      [Date_Prise_En_Main],

      [Date_Dossier],

          Date(Floor([Date_Dossier]),'DD/MM/YYYY') AS [Date_Calendar_Date_Dossier],

      [Date_Sinistre],

      SQL SELECT `Num_Dossier`,

      `Num_Sinistre`,

      `Date_Prise_En_Main`,

      `Date_Dossier`,

      `Date_Sinistre`,

      FROM `capsoffice`.`suivi`;

       

      [MinMaxDates1]:

      Load

          Min(Floor([Date_Dossier]))  AS [MinDate1],

          Max(Floor([Date_Dossier]))  AS [MaxDate1]

      Resident [suivi]

      ;

       

      Let vMinDate1 = Peek('MinDate1', 0, 'MinMaxDates1')*1;

      Let vMaxDate1 = Peek('MaxDate1', 0, 'MinMaxDates1')*1;

       

      Drop Table [MinMaxDates1];

       

      [tmp_Calendar1]:

      Load

        Date($(vMinDate1) + RowNo()-1) AS [Date1]

        AutoGenerate ($(vMaxDate1) - $(vMinDate1)+1)

          ;

      // Calendrier du Suivis des Dates Dossier => Nom de table : [Calendar_SDD]

       

      [Calendar_SDD]:

      Load

        [Date1]           As [Date_Calendar_Date_Dossier], // Renommé le champ permettra le rapprochement entre le calendrier et la table [suivi]

        Date([Date1],'DD/MM/YYYY')  AS [Date_SDD],

        MakeWeekDate(Year([Date1])-1, Week([Date1]), Num(WeekDay([Date1])))  AS [Day_Date_Y-1_SDD], // Day Name Equiv N-1

        AddYears([Date1],-1)        AS [Date_Y-1_SDD], // Date Equiv N-1

        Date([Date1],'DD')          AS [Num_Day_SDD],

        Date([Date1],'YYYYMMDD')    AS [FullDate_SDD],

        Week([Date1])               AS [Week_SDD],

        WeekName([Date1])           AS [Week_Name_SDD],

        Year([Date1])-1 & '/' & Num(Week([Date1]),'00')     AS [Week_Name_Y-1_SDD],  // Num Semaine Equiv N-1

        Num(Week([Date1]))          AS [Week_Num_SDD],

        Month([Date1])              AS [Month_SDD],

        MonthName([Date1])          AS [Month_Name_SDD],

        Num(Month([Date1]))         AS [Month_Num_SDD],

        Year([Date1])               AS [Year_SDD],

        Year([Date1]) & '.' & Week([Date1])   AS [Year_Week_SDD],

        Week([Date1]) & '.' & Year([Date1])   AS [Week_Year_SDD],

        Num(Dual(Year([Date1])&'-'&Week([Date1]), weekstart([Date1])))     AS [Year_Week_Num_SDD],

        Year([Date1]) & '.' & Month([Date1])  AS [Year_Month_SDD],

        Month([Date1]) & '.' & Year([Date1])  AS [Month_Year_SDD],

        Num(Dual(Year([Date1])&'-'&Month([Date1]), monthstart([Date1])))   AS [Year_Month_Num_SDD],

        Dual('Q'&Num(Ceil(Num(Month([Date1]))/3)),Num(Ceil(Num(Month([Date1]))/3),00))  AS [Qarter_SDD],

        Dual(Year([Date1])&'-Q'&Num(Ceil(Num(Month([Date1]))/3)),QuarterStart([Date1]))         AS [Year_Quarter_SDD]

      Resident [tmp_Calendar1]

      ;

      Drop Tables [tmp_Calendar1];