各位大神,小弟有个小问题,想把如下,如下数据(file 1122.csv),实现类似,SQL里concat 第三列 group by 第一列和第二列,输出到2233.csv里
ABCD_FEG_HFI 2T1234 Fallback
ABCD_FEG_HFI 2T1234 Large-Scan-Fine
ABCD_FEG_HFI 2T1234 Ok
我的代码
awk 'BEGIN{t=""}{a[$1","$2]=t''''" "$3;getline nl;split(nl,b);if(($1","$2) == (b[1]","b[2])){t=a[$1","$2]}else{t=""}}END{for(x in a)print x,a[x]}' 1122.csv|sort >2233.csv
但是总是把第二行丢了,请问我哪错了?结果如下:
ABCD_FEG_HFI 2T1234 Fallback Ok