Flat file content conversion repeating fields

[peter_dougherty]

Hello,

I have a flat file where the first three fields are fixed; the rest of the file line is made up of 1 .. n analysis characteristic results. The name of the field (Result) is always the same, but I never know how many results I will have on one line. Could anyone tell me how I might define this in content conversion ? Thanks in advance.

Peter DOUGHERTY.

[Former Member]

I think you'll have to define it as 1 large field (like 500 chars) or so, and loop through it in the mapping to split up the characteristics fields.

[Former Member]

Peter,

Can you give a bit clear picture of your problem?

Regards,

Sarvesh

[Former Member]

hi peter,

your issue is a bit confusing, can you give us your inbound file.

[peter_dougherty]

Sorry,

Of course ... here it is

10059514 22/09/08 8:29:02 20,2 0 0 0 0,30 0 133 0 0 0 0 0 0 0 0 0 0 0

The first field is the Id of the sample

Second field Date

Third field Time

The 4th ... 21st fields a (varying) number of results (here there are 18, but there could be any number from 1 upwards)

Hope it is clearer

Thanks

Peter

[Former Member]

Peter,

I need little bit more information about your scenario.

Can you tell me, how will be your target structure?

How are you source data is separated in incoming file, I mean with comma or something else or nothing´?

Regards,

Sarvesh

[Former Member]

Hello Peter,

Go through this blog for FCC, in this blog the FCC has been used for Unequal Number of Columns in the incoming file.

Regards,

Sarvesh