title: Concat fields in load statement
body: <p>I have a simple load statement:</p>
  
  <pre><code>LOAD FIELDA,
       FIELDB,
       FIELDC,
       FIELDD,
       FIELDE
  FROM
  [C:\Users\XXX\data.QVD]
  (qvd);
  </code></pre>
  
  <p>This loads all the data fine.</p>
  
  <p>If i add an expression into a straight table it gives me the concatenated field:</p>
  
  <pre><code> concat(FIELDA&amp;'.'&amp;FIELDB&amp;'.'&amp;FIELDC&amp;'.'&amp;IF(Isnull(FIELDD), '0', FIELDD)&amp;'.'&amp;IF(Isnull(FIELDE), '0', FIELDE)) as MERGED
  </code></pre>
  
  <p>This works, however if i try and add a concatenated field from the load statement i get an error:</p>
  
  <pre><code>LOAD FIELDA,
       FIELDB,
       FIELDC,
       FIELDD,
       FIELDE,
       concat(FIELDA&amp;'.'&amp;FIELDB&amp;'.'&amp;FIELDC&amp;'.'&amp;IF(Isnull(FIELDD), '0', FIELDD)&amp;'.'&amp;IF(Isnull(FIELDE), '0', FIELDE)) as MERGED
  FROM
  [C:\Users\XXX\data.QVD]
  (qvd);
  </code></pre>
  
  <blockquote>
    <p>Invalid expression</p>
  </blockquote>