Re^2: join column 3 values of unique values in column 1

in reply to Re: join column 3 values of unique values in column 1
in thread join column 3 for unique values

reading from table below data

__DATA__

A1 abc yellow

B1 xyz green

A2 cde red

A1 abc green

A2 cde yellow

A1 abc blue

OUTPUT

A1 abc Yellow:green:blue

B1 xyz green

A2 cde red:yellow

Comment on Re^2: join column 3 values of unique values in column 1

Replies are listed 'Best First'.
Re^3: join column 3 values of unique values in column 1 by BillKSmith (Monsignor) on Sep 06, 2016 at 12:58 UTC
You still have not addressed my important question about field 2. Can we be certain that all input entries which have the same field 1 will have the same field 2? If not, how do you handle it? Report an error? Make separate output lines for each field 1/field 2 combination? Arbitrarily choose one of the field 2 values for the output? Bill	[reply]
Re^4: join column 3 values of unique values in column 1 by Anonymous Monk on Sep 06, 2016 at 13:34 UTC
yes, the column 2, 5,6 values will be same for unique col 1 values.	[reply]

In Section Seekers of Perl Wisdom