2 Replies Latest reply: May 8, 2014 7:02 AM by Marcus Sommer RSS

    How and in which order executed QV a load-statement?

    Marcus Sommer

      Hello,

       

      how and in which order executed QV a load-statement?

       

      Background is to check within a load-statement if a certain field exists and if not load a dummy-value or another field. But a check like:

       

      Load

      ....

      if(year < 2014, 'n.n.', [Field X]) as [Field X],

      ....

      From path/file*.txt

       

      within a load returned a load-error (field not found) if [Field X] don't exists. This don't failed only by internal field-checks but also by file-functions like:

       

      if(makedate(mid(filebasename(), 11, 4), mid(filebasename(), 16, 2), 1) < '01.01.2014', 'n.n.', [Field X]) as [Field X],

       

      Is there any possibility to solve this within a load-statement and avoiding several loads or loops around the load to create a variable load-statement?

       

      Many thanks, Marcus.