4 Replies Latest reply: Feb 3, 2011 5:27 AM by Bob McMeekin RSS

    If then elseif

      Hi there

      I currently have the following within my script to load a qvd file :

      if(CT_YEAR = 'C', 2010, if(CT_YEAR = 'L', 2009)) as [ACYear],

      I'd like to cater for another option 'N' :

      if CT_YEAR = 'C' then
      ACYear = '2010'
      elseif CT_YEAR = 'L' then
      ACYear='2009'
      elseif CT_YEAR = 'N' then
      ACYear ='2011'
      endif

      Can anyone advise how to set this up within the load script?

      Thanks

      Bob