2 Replies Latest reply: Sep 17, 2015 2:34 AM by Guillermo Lo-Kioeng-Shioe RSS

    SubStringCount(Concat Question

    Guillermo Lo-Kioeng-Shioe

      Hi,

       

      I have a problem with my  SubStringCount(Concat conditional option in my table.

       

      Right now im using:

       

      LOAD * INLINE [dimension_1,dimension_flag

       

      Month,1

      Date, 2

      Etc.


      And


      LOAD * INLINE [Parameter_1, Parameter_flag

       

      Budget, A

      Tax, B

      Etc.

       

      In my script to determine what dimensions and expressions I want to show/hide in my table.


      The problem i'm running into is that whenever I use 10 as a dimension_flag: 10, 1, and 0 get selected in my table. Is there any way how I can add more than 10 dimensions without causing this problem?

       

      Thanks in advance.