8 Replies Latest reply: Aug 28, 2014 7:45 AM by Martyn Lloyd RSS

    Use field content as name in load

    Martyn Lloyd

      Does anyone have a solution for variable field names, based on table content, in a Load statement?

       

      There are lots of posts on this subject, but I can't find any solutions.

       

      Example, this would be ideal if it worked...

       

      LOAD 
          
      DealerID,
          
      KPIYear,
          
      [KPI Description],
          
      Delivered as $([KPI Description])
      FROM
      $(vQVDPath)\KPDAllDeliveries.qvd (qvd)
      Where KPIID='S1';

       

       

      Regards,

      M.