7 Replies Latest reply: Jun 30, 2015 11:17 AM by Adrian Buzer RSS

    Multiple Excel files and preceding load

    Adrian Buzer


      Hi

       

      I am trying to load multiple Excel files which are all in the same format with the same field names and number of fields.  I am calculating new fields and also calculating new fields from the calculated fields using a preceding load.  The result is that I have 1 table with the 3 extra fields calculated in the preceding load, 1 table with just the original field names and a synthetic key table as follows

       

      Table 1

      $Syn 1

           field1         

           field2

           field3

           field4

      calcfield1

      calcfield2

      calcfield3

       

      Table 2

      $Syn 1

           field1

           field2

           field3

           field4

       

      $Syn 1 Table

      field1

      field2

      field3

      field4

       

      How can I prevent the creation of the synthetic key?

      Thanks