Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Sorry i have maked a error, my file seems good now. You can delete this thread.
I didn't smoke the carpet.
Sorry i have maked a error, my file seems good now. You can delete this thread.
I didn't smoke the carpet.
Sorry i have maked a error, my file seems good now. You can delete this thread.
I didn't smoke the carpet.