1 Reply Latest reply: Mar 17, 2013 6:33 AM by Stefan Wühl RSS

    Change or replace some data in the LOAD script

      Hi all,

       

      I load transactiondates from an auditfile. All the dates are correct but there are a few transactions who have a transactiondate 30-06-2011. I need to replace this date 30-06-2012 in 01-07-2012. The change is necessary otherwise the transaction related with this date wil not be presented in the correct Fiscal Year.

      How can I rename or convert the date 30-06-2012 in the LOAD script to 30-06-2011?

       

      Hope someone can help.

       

      Thx in advance,

      Rudy

        • Re: Change or replace some data in the LOAD script
          Stefan Wühl

          If it's just about a single value you need to check and transform, I would use a conditional statement (i.e. if() statement ) in your load:

           

          LOAD

            if( DATEFIELD = makedate(2012,6,30), makedate(2012,7,1), DATEFIELD) as DATEFIELD,

          ....

          FROM ....;

           

          Your DATEFIELD should already be interpreted as date by QV, if not (i.e. still pure text, no numerical representation), use the date#() function to interpret your DATEFIELD as date.

           

          Hope this helps,

          Stefan