You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » Rearranging of a CSV file.
Post a reply
Topic review (newest first)
- gfliss
- 2008-06-23 20:40:15
Thank you very much for your help!
-Greg
- shong
- 2008-06-23 08:50:29
Hello
Thanks for your interest in TOS!
Here is the user documentation.
Field1,1234567890
Field2,1234567890
Field3,1234567890
Field1,0987654321
Field2,0987654321
Field3,0987654321
How can I transform the data above to the correct format?
First, you can use a tFilterRow/tMap component to get the second row.
1234567890
1234567890
1234567890
0987654321
0987654321
0987654321
Then, pull multiple lines and put them into one row. See topic:2017.
Feel free to post your questions on forum!
Best regards
shong
- gfliss
- 2008-06-20 21:02:55
Hi,
I am spearheading a data collection project that is requesting data from a lot of different resources. I've explained to all the sources what I need in the CSV file (here's the shortened version):
Field1 Text 10
Field2 Text 10
Field3 Text 10
And a good majority of the data comes back in the expected fashion:
1234567890,1234567890,1234567890
0987654321,0987654321,0987654321
However, there are a few of them that send the data back in this format:
Field1,1234567890
Field2,1234567890
Field3,1234567890
Field1,0987654321
Field2,0987654321
Field3,0987654321
How can I transform the data above to the correct format? Since I'm new to Talend, I think I'm trying to find a single step to transform the data. Is this possible or do I need more than one step?
Any help would be greatly appreciated.
Thanks,
-Greg