9 Replies Latest reply: Nov 13, 2013 2:30 AM by Jean-Paul Camelbeek RSS

    Load Script

      Hi All

       

      I need some help with load scripts:

       

      I have a standard load script loading some data from excel sheet which is fine, i have a rather complicated if structure to calculate a value, lets call it 'Calculated Value A' which i save to the table structure, this all works great.

       

      However in the same load script i want to access 'Calculated Value A' which I have just created and use it in further calculations, rather than just repeating the whole complicated if structure again is there a way to gain access to the value in the field that has just been created? 

       

       

      Load

           line 1

           line 2

           if (  if ( if ( etc ))) as [Calculated Value A]

       

           if [Calculated Value A] = 'Yes' then do something

       

      From

           etc etc

       

      Thanks

      JP