This content has been marked as final. Show 2 replies
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;
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?