3 Replies Latest reply: Feb 2, 2016 7:39 PM by jagan mohan rao appala RSS

    Create an Array from field values

    Ian McGivern

      Good Day,

       

      Has anyone created a field with an array of values?

       

      Below is script that demonstrates what I'm trying to achieve.

       

      The desired output is for [Inner Table] to have the following:

       

      Inner CodeInner Value
      1A, B, C
      2D, E, F
      3G, H, I

       

       

       

      [Data_Table]:
      load * inline [
      Code, Value
      1, A
      1, B
      1, C
      2, D
      2, E
      2, F
      3, G
      3, H
      3, I
      ];


      For Each x in FieldValueList('Code')

          Let vCurrentCode = $(x);
         
          [Outer Table]:
          LOAD
           '$(x)' as "Outer Code"
          AutoGenerate 1;
         
         
          For Each y in FieldValueList('Code')
          
              Let ConcatenatedValue = ConcatenatedValue & ' ' & Peek('Value',y,'Data_Table') & ',';

              [Inner Table]:
                    LOAD
                    '$(x)' as "Inner Code",
                    '$(ConcatenatedValue)' AS "Inner Value"
              AutoGenerate 1
                   Where
                         $(x) = $(vCurrentCode);
             
              Let content = Null;
             
          Next y
         
      Next x