How to convert a single row into multiple rows

Posted on August 20, 2009 at 2:27pm

Hi,

I have a file that contains fields in a single row e.g

12,13,45,01,05

I would like to write out these fields as seperate rows in a new file e.g

How do I go about it?

I would appreciate any help.

Thanks

jstrydom

Joined: Aug 19 2009 - 5:36pm

Last seen: 14 years 1 month ago

3 Answers:

Posted on August 24, 2009 at 5:26am

I believe the tNormalize component should meet your request.

Basically all you need to select is Column and Item seperator.

HTH

Cheers,

Stas

stasp

40398

Joined: Jun 3 2009 - 9:53am

Last seen: 1 week 14 hours ago

Posted on August 24, 2009 at 12:06pm

Thanks,

I'm just wondering wich column to select, because it's not really a normalization. Do you have to select a column?

Johan

jstrydom

Joined: Aug 19 2009 - 5:36pm

Last seen: 14 years 1 month ago

Posted on August 26, 2009 at 6:09am

Although it's not really a normalization, you are putting values into some column. I'm not sure if it'll work properly without any column defined.

The component description says: "Select the column from the input flow which the normalization is based on"

You'll have to try and see how it works, but I guess you'll need to define some column name if you don't have one.

stasp

40398

Joined: Jun 3 2009 - 9:53am

Last seen: 1 week 14 hours ago