10 Replies Latest reply: Jul 12, 2018 10:46 AM by Mohammed Ajeddig RSS

    joining 3 tables and loadind specific data

    Mohammed Ajeddig

      Hey guys:

      I have 3 tables   FactTicket    and    FactTicketActivity   and   Applications. i would like to join between them and load from the joind data all rows exception rows  that have    IsAutoCap=1     and   Catégorie H2= 'New IT T2'   and   ActivitySDTier =  '3'

       

      this is my script :

       

      FactTicket:

      LOAD

      %TicketKey,

      %CIApplicationName,

      IsAutoCap

      from 

      [.\..\FactTicket_Data_2017.qvd]

      (qvd) ;

       



      FactTicketActivity:

      LOAD

      %TicketKey,

      ActivitySDTier

      from

      [.\..\FactTicketActivities_Data_2017.qvd]

      (qvd);



      Applications:

      LOAD

      %CIApplicationName,

      Catégorie H2

      from

      [.\..\SD\Ref_Applications.qvd]

      (qvd);


       

      left join (FactTicket)

      load * resident FactTicketActivity;

       

       

      left join (FactTicket)

      load * resident Applications

       

       

      WHERE [Catégorie H2] <> 'New IT T2' AND ActivitySDTier <> '3' AND  IsAutoCap <> '1' ;

       

      But i got this error 

       

      Field not found - <ActivitySDTier>

      left join (FactTicket)

      load * resident Applications

      WHERE [Catégorie H2] <> 'New IT T2' AND ActivitySDTier <> '3' AND  IsAutoCap <> '1'


      thanks guys