5 Replies Latest reply: Mar 2, 2016 8:04 AM by Simone Trabattoni RSS

    Load from different sources and merging the results

    Simone Trabattoni

      Hi Qlik Experts!

       

      I have a question about load datas from difference sources.

      Let's explain with an example:

      first, I have this table from DataBase 1:

       

      Table1:

      LOAD

      *

      ;

      SQL SELECT

      Person

      FROM DataBase1;

       

      The result is:

      Person
      p1
      p2
      p3
      p4

       

      Now, I should do the same thing with DataBase2:

       

      Table2:

      LOAD

      *

      ;

      SQL SELECT

      Person

      FROM DataBase2;

       

      The result is:

      Person
      p1
      p2
      p5

       

      I decide to use both the script in the same time (and I need one table), so the result is clearly this:

       

      Table1_2:

      LOAD

      *

      ;

      SQL SELECT

      Person

      FROM DataBase1;

       

      Table1_2:

      LOAD

      *

      ;

      SQL SELECT

      Person

      FROM DataBase1;

       

      Person
      p1
      p2
      p3
      p4
      p1
      p2
      p5

       

      Now the question: could I do a " distinct" of the last table (and how)? In other words, could I reach (and how) this result?

       

      Person
      p1
      p2
      p3
      p4
      p5

       

      Thanks a lot for your time!