6 Replies Latest reply: Nov 25, 2012 9:33 AM by Przemysław Wojda RSS

    Omit dimension when not found

    Przemysław Wojda

      Hi All,

       

      using a loop I need to load data from tables where some dimensions are common between the tables, some are not. What should I put into load code so that all tables can be loaded by a single load (i.e. when dimension was not found load all other without raising an error)? In the below example I'd like to load all data from Table1 and Table2, using a single load code, to get Table3.

       

      Regards,

      Przemek

       

      INPUT
      
      Table1: 
      FirstName, Color
      John, Blue
      
      Table2: 
      Color, City
      Red, Berlin
      
      OUTPUT
      
      
      Table3:
      FirstName, Surname, City
      John, Blue, Null
      Null, Red, Berlin