All right this may be one of those things that could be totally easy to do, so my apologies in advance community I know you guys are busy for my rookie questions.
I have a numeric ID, I need to convert it into a single field comma delimited so I can feed a dynamic input. The trick is that the amount of records could vary from time to time, so I am looking for a 'dynamic' solution.
I originally thought 'Cross Tab' to transform the data into rows and then use 'Multy-Field-Formula' to create the string needed, but that didn't work... Then I used a 'multi-row' formula to avoid the transformation altogether and it seems to be working but that would work only if I new how many where there, how would I make that logic dynamic to adapt to N number of records?
My logic: (which in this case works because I know I only have 3 values)
ToString([SEQ])+','+ToString([Row+1:SEQ])+','+ToString([Row+2:SEQ])
Thanks in advance for your help,
