compare 2 csv files for catching exceptions

[gadje1]

Hi everybody and thanks in advance for those who will help me.

I would like to compare 2 csv files and catch lines that not match.

My job structure is like thaht :

and my tMap :

In first i have a csv file generated from an sql query (COPAB) and another csv file generated from an XLS file (UAB).

In my tMap i created an inner join between the field "ORCAB_CD" in UAB file and "CDGRP" in COPAB file.

In my output "out_NoMatch" i setted "Catch lookup inner join reject" to true.

My problem is that i don't catch some codes that did must been in the reject file.

Obviously, i checked if the code was well in both files and it's.

This is a part my "COPAB" csv file structure :

CDGRP;NOART;ETARE;ART93;REFFO
;DI0031;;;
OR00006702;OR00006702;;6017;775657
OR00006705;OR00006705;;6022;775659
OR00010485;OR00010485;;30221;741930
OR00619925;OR00619925;;650060101Z;752394
OR00619940;OR00619940;;553_59_901;776165
OR00619941;OR00619941;;553_59_902;776166
OR00619942;OR00619942;;553_59_903;776167
OR00619943;OR00619943;;553_59_904;776168
OR00619944;OR00619944;;553_59_905;776169
OR00010486;OR00010486;;30223;741928
OR00010487;OR00010487;;30224;741929
OR00010491;OR00010491;;30251;765169
OR00010492;OR00010492;;30253;765167
OR00010493;OR00010493;;30254;765168
OR00010635;OR00010635;;31203;765166
OR00010787;OR00010787;;31913;750714
OR00010788;OR00010788;;31916;750713
OR00010804;OR00010804;;31955;750715

And this is a sample of my "UAB" csv file :

UAB_CD;ORCAB_CD;DES_LIB;COPA_PU;ADH_PU;DISPO_CD;CQ2019_LIB;AUTRECOOP_LIB;UV_CD;US_CD;UF_CD;MV_COEF;MF_COEF;SENSCOEFUVUS_CD;SENSCOEFUFUS_CD;TECHNIQUE_LIB;creation_dt;modification_dt;validite_tarif_dt;reference_fournisseur;mots_cles
100029;OR00617441;CHEVILLE INCO 8MM L 150MM POUR ISOLANT 120MM      ;0,12;0,17;D;CQ2019-2 Pg:138 Px:28.510 Rf:OR00617441                           ;CQ2019- Info Stock : ARBA ACEM GMB UAB                            ;U   ;U   ;U   ;1;1; ; ;VENDU A L'UNITÉ;15/12/09;17/09/18;01/04/2019;358406;OR00617441@
100329;OR02413723;POT DE RETRAITEMENT DES COUPES - PCD 91 VERT 2,5L ;18,74;22,96;D;CQ2019-3 Pg:155 Px:42.280 Rf:OR02413723                           ;CQ2019- Info Stock : ARBA ACEM CAB UAB                            ;BIDO;BIDO;BIDO;1;1; ; ;VENDU AU BIDON - BIDON DE 2,50 LITRES;13/02/07;28/01/20;01/01/2020;182;OR00234719@OR02413723@
776256;OR01725261;CHARNIERE DUOMATIC PREMIUM 110 52/5,5 SS OUTIL DRO;2,27;2,95;C;;;U   ;U   ;U   ;1;1; ; ;;11/04/12;05/01/18;01/01/2018;329.17.770;OR01725261@
776165;OR00619940;KIT 2 TUBES LONGITUDINAL GRIS LG=300MM            ;2,67;3,4;D;;;U   ;U   ;U   ;1;1; ; ;;11/04/12;29/03/18;29/03/2018;553.59.901;OR00619940@
752275;OR00210507;PIQUET BOITE AUX LETTRES CYLINDRIQUE GALVA        ;12,85;17,01;D;;;U   ;U   ;U   ;1;1; ; ;;29/10/08;20/03/19;20/03/2019;139286;OR00210507@
751800;OR00619914;BURETTE HUILE 125ML P/CLOUEUR                     ;3,9;4,96;D;;;U   ;U   ;U   ;1;1; ; ;;24/06/08;20/06/18;01/03/2018;HBP125;OR00619914@
775138;OR00192173;POUDRE DE TRACAGE BLANCHE 1KG                     ;4,8;6,59;D;;;U   ;U   ;U   ;1;1; ; ;;12/03/12;12/02/20;12/02/2020;400426;OR00192172@OR00192173@
776191;OR00619960;REHAUSSE LATERAL MOOVIT PANEL LG=600MM            ;15,02;19,14;D;;;U   ;U   ;U   ;1;1; ; ;;11/04/12;05/01/18;01/01/2018;553.60.207;OR00619960@
777865;OR00226968;VESTE COUPE VENT IMPER.TECKA BLEU MARINE T.58     ;30,35;40,97;C;;;U   ;U   ;U   ;1;1; ; ;;25/07/17;10/04/20;10/04/2020;V415-0-02.Z58;OR00226968@
775531;OR00180254;CHEVILLE FH 10/25 S LG 99MM ACIER ZG BT 50        ;138,6;190,23;D;;;BOIT;BOIT;CENT;1;0,5; ; ;;16/03/12;08/04/20;01/02/2020;503134;OR00180254@
773597;OR01390346;CLOUEUR POINTES ROULEAUX BARDAGE ET COUVERTURE    ;521,12;677,45;C;;;U   ;U   ;U   ;1;1; ; ;;05/03/12;06/03/18;01/03/2018;CN452S;OR01390346@
100741;OR00617439;CHEVILLE INCO 8MM LONG 100MM POUR ISOLANT 80MM    ;0,11;0,14;D;CQ2019-2 Pg:138 Px:25.170 Rf:OR00617439                           ;CQ2019- Info Stock : ARBA CAB GMB UAB                             ;U   ;U   ;U   ;1;1; ; ;VENDU A L'UNITE - CARTON DE 500 CHEVILLES;01/01/98;29/04/19;01/04/2019;358402;OR00617439@

For example, the code "OR00619940" is well present in both files but isn't in my reject file.

Any idea why ?

Thanks a lot.

[gadje1]

Sorry i have maked a error, my file seems good now. You can delete this thread.

I didn't smoke the carpet.

[gadje1 · Accepted solution]

Sorry i have maked a error, my file seems good now. You can delete this thread.

I didn't smoke the carpet.