2 Replies Latest reply: Aug 3, 2015 4:07 AM by Daniel Nasseh RSS

    Joining multiple residents taking forever

    Daniel Nasseh

      Hello,

       

      i think i am doing something wrong.

       

      So basically this is a follow up questions to this thread:

      Bar Diagram - Each bar another function

       

      Here was a solution which worked for me - a concatenated table:

       

       

      ControlNumber:

      LOAD personids,

                'ControlNumber1' as ControlNumber

      RESIDENT TABLE_FROM_FILE1

      WHERE hair_color = 'blond';

       

      CONCATENATE (ControlNumber)

      LOAD personids,

               'ControlNumber2' as ControlNumber

      RESIDENT TABLE_FROM_FILE1

      WHERE hair_color = 'blond' AND eyes='blue';

       

      So far so good. Now unfortunately, i need to load Value snot only from one Table but from multiple tables.

      So basically what i would need is something like this (joining multiple resident tables):

       

      CONCATENATE (ControlNumber)

      LOAD personids,

               'ControlNumber2' as ControlNumber

      RESIDENT T1 JOIN T2

      WHERE t1.hair_color = 'blond' AND t2.eyes='blue';

       

      Now i found some solutions but those solutions make my Qlik-View crash.

      For instance if i do the following:

       

      tempx:

      LOAD

           t1.PID

           Resident T1;

       

      JOIN(tempx) LOAD

          t2.PID

          Resident T2;

       

      ControlNumber:

      LOAD personids,

                'ControlNumber1' as ControlNumber

      RESIDENT tempx

      WHERE hair_color = 'blond';

       

      CONCATENATE (ControlNumber)

      LOAD personids,

               'ControlNumber2' as ControlNumber

      RESIDENT tempx

      WHERE hair_color = 'blond' AND eyes='blue';

       

      Actually i tried out a lot of different ways how to solve this but most of the time my attempts of joining those tables lead to, like i said, Qlik-View crashing. Like i said - i can easily load the contents of one table, but at the moment not sure how to get contents from both tables.

       

      Best Regards,

      Daniel