Hi,
I am running v3.1.7.0 of ETL Pro.
I am having huge difficulties with doing a very simple and standard ETL type procedure and I would be very grateful for your help. I have a text input file, formatted thus:-
House No, Name (note these items are not included in the file – ie there is no header)
1, Fred
1, Eric
1, Josie
2, Cedric
2, Tim
2, Sue
3, Scoobie
3, Jane
I want to sort this into a simple ‘row’ based CSV file – ie:-
1, Fred, Eric, Josie
2, Cedric, Tim, Sue
3, Scoobie, Jane
I am having great difficulties with this. I have tried using ‘Grouper’ and ‘Pivot’, but I am really struggling to understand these tools from the documentation provided.
Also, I would be grateful if you could tell me if I can upgrade my current version of ETL Pro (being a fully ‘paid up’ license holder).
Regards
Steve
