5 Replies Latest reply: Jan 17, 2012 6:31 AM by Vijay Kumar RSS

    Loading all fields and changing one

    Donald Posthuma

      Hi!

       

      I have the following issue. I need to load all fields from a QVD file where I need to change one of them. To keep the script adaptive to the adding and removing of fields I would like to use the * instead of the field names. After I have changed one of the fields the table needs to be concatenated to another table. Any ideas of doing this without to many temporary tables? Ideally the script would look something like this:

       

      Concatenate Load

           * (without field x),

           field x

      From

           temp.QVD;

       

      Thanks for any help!