I have csv file, which has data,
Server,Department
testserver,Fin Tech
testserver,Fin Tech
testserver,Fin Tech
testserver,Fin Tech
testserver,Fin Tech
testserver,Fin Tech
testserver,HR
testserver,Fin Tech
testserver,Fin Tech
testserver,Fin Tech
testserver,Fin Tech
testserver,Fin Tech
testserver,HR
testserver,Fin Tech
testserver,Fin Tech
I need to keep all values in single field by concatenating them, but it should be unique.
eg: Fin Tech/HR
but I am getting result as Fin Tech/Fin Tech/Fin Tech/Fin Tech/Fin Tech/Fin Tech/HR/Fin Tech/Fin Tech/Fin Tech/Fin Tech/Fin Tech/HR/Fin Tech/Fin Tech
if [ -n "$current_Department" ] || [[ "$current_Department" == *"Department"* ]]; then
bs_name="$current_Department/$Department"
fi
New contributor
Jami is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Using any awk:
$ awk '
BEGIN { FS=OFS="," }
NR==1 { print; next }
!seen[$1,$2]++ {
depts[$1] = depts[$1] seps[$1] $2
seps[$1] = "/"
}
END {
for (srvr in depts) {
print srvr, depts[srvr]
}
}
' file
Server,Department
testserver,Fin Tech/HR