11 Replies Latest reply: Jun 10, 2014 8:45 AM by Erik Furlanis RSS

    preceding load with concatenated tables load

      I am combining several tables into one and need to filter on one field together with making sure values are unique.

       

      I thought about using the preceding load and came up with something like below:

       

      LOAD DISTINCT *
      WHERE field3='A';
      
      LOAD
      field1,
      field2,
      field3;
      SQL SELECT * FROM table1;
      
      CONCATENATE LOAD
      field1,
      field2,
      field3;
      SQL SELECT * FROM table2;
      
      CONCATENATE LOAD
      field1,
      field2,
      field3;
      SQL SELECT * FROM table3;
      

       

      It is not working though, because all values in field3 are still available.

      What am I missing out?

       

      thanj you!