You are not logged in.
Announcement
Unanswered posts
|
Pages: 1

hi, i have a little problem to concatenate each record in an output file, that is, i have my input file information with next:
27600|2002/02/28|Maintenance Fee 2002| 21.74
27600|2003/02/28|Maintenance Fee 2003| 325.00
27600|2004/02/28|Maintenance Fee 2004| 343.00
27600|2005/02/28|Maintenance Fee 2005| 363.00
and that i want to get is:
27600 | null | 2002/02/28;2003/02/28;2004/02/28;2005/02/28 | Maintenance Fee 2002; Maintenance Fee 2003;Maintenance Fee 2004; Maintenance Fee 2005 | 1052.74
i tried with, taggregaterow, tforeach, components; and i can concatenate, but the concatenating is:
27600 | null | 02/28/2002 | Maintenance Fee 2002;Maintenance Fee 2002;Maintenance Fee 2002;Maintenance Fee 2002 | 21.74
27600 || null | 02/28/2003 | Maintenance Fee 2003;Maintenance Fee 2003;Maintenance Fee 2003;Maintenance Fee 2003 | 325.00
27600 | null | 02/28/2004 | Maintenance Fee 2004;Maintenance Fee 2004;Maintenance Fee 2004;Maintenance Fee 2004 | 343.00
27600 |null | 02/28/2005 | Maintenance Fee 2005;Maintenance Fee 2005;Maintenance Fee 2005;Maintenance Fee 2005 | 363.00
well i upload a few pictures for better explain of my problem. The null field itīs ok, as it has to be.
I hope someome can helps me, please any idea.
Thanks Best Regards.
Offline
Pages: 1