• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » HOWTO ? : Split on field and generate (duplicate) rows

#1 2007-04-24 15:48:42

Mglcel
Guest

HOWTO ? : Split on field and generate (duplicate) rows

Hello,

  I could not found how to do this job (here simplified from the real case) :

1/ One excel file with two columns : server, platforms
2/ The field server contains the name of a server
3/ The field contains one or more platforms (a server could be shared on different platforms), comma separated (ex: 'PF1, PF2, PF3')

for this example :

server1   'PF1'
server2   'PF2, PF3'
server3   'PF3, PF1, PF2'
server4   'PF2'

i want to generate :

server1   PF1
server2   PF2
server2   PF3
server3   PF3
server3   PF1
server3   PF2
server4   PF2

Please, could you explain me which components to use ?
I can use a perl component but i am not sure how to create a new row on output.. ?

using a map and the value 'split /,/, $row1[platform]' i can count the number of platforms for a server but i don't know how to use it with efficiency.. wink

Thanks a lot for your help.

#2 2007-04-24 15:50:56

Mglcel
Guest

Re: HOWTO ? : Split on field and generate (duplicate) rows

correction: 3/ The field platforms contains one or more platforms

#3 2007-04-24 16:53:59

Mglcel
Guest

Re: HOWTO ? : Split on field and generate (duplicate) rows

OK, linked to [Forum, topic 329] splitting a string into rows.
Sorry for the post.

#4 2007-04-28 00:35:32

Mglcel
Guest

Re: HOWTO ? : Split on field and generate (duplicate) rows

see [Forum, topic 640] [Flow management] tMerger/tNormalize or "How to generate extra rows"

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » HOWTO ? : Split on field and generate (duplicate) rows

Board footer

Powered by FluxBB