You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
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.. ![]()
Thanks a lot for your help.
correction: 3/ The field platforms contains one or more platforms
OK, linked to [Forum, topic 329] splitting a string into rows.
Sorry for the post.
see [Forum, topic 640] [Flow management] tMerger/tNormalize or "How to generate extra rows"
Pages: 1