Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
joris_lansdaal
Creator
Creator

For each .. syntax for values starting with a number

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;

1 Solution

Accepted Solutions
sunny_talwar

May be this:

FOR Each b in ....,'10Y_ABND_costs',.....

      Concatenate(Budget)

            Load  PnL_Lines,

              .......

            Bedrag as [$(b)],

            .......

              resident Budget_Temp

            Where PnL_Lines = '$(b)' ;

  Next

View solution in original post

2 Replies
sunny_talwar

May be this:

FOR Each b in ....,'10Y_ABND_costs',.....

      Concatenate(Budget)

            Load  PnL_Lines,

              .......

            Bedrag as [$(b)],

            .......

              resident Budget_Temp

            Where PnL_Lines = '$(b)' ;

  Next

joris_lansdaal
Creator
Creator
Author

Thanks Sunny.