In the input file format(CustomerID, Value) given below, there will be a maximum of 3 records for a "CustomerID" with three different "Value".
I need to change the layout as
CustomerID Value1 Value2 Value3
The CustomerID that have only one Record in the input file should have the corresponding "Value" in "Value1" field of the output file and Zeroes in "Value2" and "Value3". How can this be done using SORT(SYNCSORT)