2 Replies Latest reply: Jul 1, 2015 6:02 PM by Massimo Grossi RSS

    Join Functionality Problem

    Chandra Mouli Javvadi

      Here in the show script you can find two main tables Event and Intervals.

       

      If I try to merge the both tables in the data model it is working succesfully. In data model we can see one resultant table

       

      But while I'm trying to merge the both Resident tables it is not showing the resultant table

       

      It is still showing two separate tables as Event , Intervals

       

      //Join Prefix

      Event:

      LOAD EventID,

           Date(Date#(EventDate,'YYYY-MM-DD'))as MyDate

      FROM

      [A:\QV Training Docs\1. Simple IntervalMatch\Events.txt]

      (txt, utf8, embedded labels, delimiter is '\t', msq);

       

      Intervals:

      LOAD IntervalID,

           Date(Date#(IntervalEnd,'YYYY-MM-DD'))as ToDate,

        Date(Date#(IntervalBegin,'YYYY-MM-DD'))as FromDate

      FROM

      [A:\QV Training Docs\1. Simple IntervalMatch\Intervals.txt]

      (txt, utf8, embedded labels, delimiter is '\t', msq);

       

       

      //// ============ Merge two resident tables using a join ============

      Temp:

      Load

        EventID,

        MyDate

        Resident Event;

      Join

      Load

        IntervalID,

        ToDate,

        FromDate

        Resident Intervals;

       

      Plz solve my issue

       

      Thanks Inadvance