UNIX for Dummies Questions & Answers

Code:

awk 'END { for (k in x) 
print k, x[k], y[k] }
{ x[$1FS$2FS$3] = x[$1FS$2FS$3] ? x[$1FS$2FS$3] ";" $4 : $4
y[$1FS$2FS$3] = $5 } ' FS=\| OFS=\| Test_File.dat

Code:

x[$1FS$2FS$3] = x[$1FS$2FS$3] ? x[$1FS$2FS$3] ";" $4 : $4

x is an associative array with keys based on your logical primary key $1, $2 and $3 and values/elements based on the value of the fourth filed.
The if expression ? then : else statement is composing your elements in the desired format (if array[key] exists -> then append $4 to its value).

Code:

y[$1FS$2FS$3] = $5

Another associative array with the same keys and elements based on the last field.

Code:

END { for (k in x) 
print k, x[k], y[k] }

After reading the entire input for every key in the x array,
print the desired values: the x key, the x value and the y value.

Hope this helps.