2 Replies Latest reply: Sep 12, 2016 8:42 AM by Joris Lansdaal RSS

    For each .. syntax for values starting with a number

    Joris Lansdaal

      Hi All,

       

      I've got a syntax issue i can't solve. Below script gives an error on '10Y_ABND_costs'; because it starts with a number.

      I've tried Double quotes, brackets and combinations, but then there's no match with my PNL_Lines value.

       

      Can anyone help me with the right syntax for this value '10Y_ABND_costs'?

       

      FOR Each b in ....,'10Y_ABND_costs',.....
             Concatenate(Budget)
                  Load  PnL_Lines,
                    .......
                  Bedrag as $(b),
                   .......
                    resident Budget_Temp
                   Where PnL_Lines='$(b)' ;
        Next


      drop tables Budget_Temp;