ITADN

join with unpaired records results in CSV schema change error

#1898Closedthe42 创建于 2025-10-15
T
the42commented
given two simple csv files: l.csv: id,bezeichnung,id kompo 1,Hallo,500 2,Blah,20 r.csv id,cbezeichnung 500,Welt the joining columns are 'id' and 'id kompo' So l.csv contains a line 2,Blah,20 for which there is no matching record in file r.csv When I call mlr -c join -f l.csv --lp app_ --ul --rp komp_ -j 'id kompo' -r id r.csv the command fails with the error message: mlr: CSV schema change: first keys "id kompo,app_id,app_bezeichnung,komp_cbezeichnung"; current keys "id,bezeichnung,id kompo" mlr: exiting due to data error. The command succeeds yet doesn't print the non-matching lines when I omit --ul
关闭于 2025-10-17 2 条评论