2 Replies Latest reply: Aug 9, 2013 4:45 PM by Enrique Martínez RSS

    How to number SubField results?

      I need to number the SubField() function results so you can identify each part individually, see the code:

       

      Source:
      Load * Inline [
      Id, Text
      1, ‘part a,part b,partc’
      2, ‘part a,part d,part e’
      ];
      
      SubFields:
      Load Id, 
      SubField(Text,’,’) as SubText, 
      magicfunction() as Order
      Resident
                      Source;
      

       

      Expected result:

       

       

      Id     SubText     Order

      1     part a          1

      1     part b          2

      1     part c          3

      2     part a          1

      2     part d          2

      2     part e          3

       

      Right now I'm using RecNo() generating secuential number but gives me huge numbers for the last records.

       

      Any idea what magicfunction() can be?

       

      Thank you!

       

      Enrique.