Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem with a returned value in tMap.
My job looks like that :
In my tMap, i tried :
row3.NOMLV!=null? .....
!row3.NOMLV.equals(null)?....
to use Relational.ISNULL(row3.NOMLV)?"000000"
To check null values
Here is the line given as error :
The expression in my tMap for check null value is like that :
Hi
From your screenshot, i see 0 rows are read from addres_liv... database, 0 row means the lookup table tAs400Input_4 will not execute. Can you check if it is normal if returning 0 row?
Regards
Shong
Hi Shong thanks for your reply,
I changed my job structure, i use 2 csv files in tMap now.
My job look's like that :
My tMap is like that :
I need to change the value of "Out_01.Adresse_livraison_prenom" if row1.NOLIV is different of 000001, 000002, 000003, 000004 or 000005 like this row2.ADRESSE_LIVRAISON_PRENOM value instead of row1.Adresse_livraison_prenom value. But there is no value returned as show in first screenshot, in console output.
In this sample i test with AD141 user account that have "009449" in last column (NOLIV) :
Commande_numero|Commande_date_validation|Adherent_code|Utilisateur_code|Utilisateur_nom|Utilisateur_prenom|Commande_numero_internet|Panier_libelle|Commande_prix_total_ht|Commande_commentaire|Commande_reference|Commande_type|Mode_livraison_code|Commande_date_livraison_souhaitee|Commande_semaine_livraison_souhaitee|Commande_date_livraison_ferme|Adresse_livraison_libelle|Adresse_livraison_civilite|Adresse_livraison_nom|Adresse_livraison_prenom|Adresse_livraison_societe|Adresse_livraison_adresse|Adresse_livraison_adresse_complementaire|Adresse_livraison_code_postal|Adresse_livraison_ville_nom|Adresse_livraison_pays_nom|Adresse_livraison_telephone|Adresse_livraison_portable|Adresse_livraison_ignoree_par_erp|Ligne_numero|Ligne_nature|Ligne_code|Ligne_fournisseur_reference|Ligne_fournisseur_nom|Ligne_designation|Ligne_quantite_commandee|Ligne_unite_quantite_commandee|Ligne_quantite_facturation|Ligne_unite_quantite_facturation|Ligne_prix_unitaire_ht|Ligne_prix_total_ht|Ligne_article_divers|Ligne_commentaire|Ligne_options|Ligne_dimensions_variables|Ligne_devis_numero|Ligne_devis_numero_ligne|Ligne_bon_de_choix_numero|Ligne_bon_de_choix_numero_ligne|Commande_nombre_pieces_jointes|Adresse_livraison_latitude|Adresse_livraison_longitude|Commande_email_suivi|Utilisateur_code_connexion_en_tant_que|Utilisateur_email_connexion_en_tant_que|Utilisateur_nom_connexion_en_tant_que|NOLIV
546500|2020-09-18 11:26:25|CO023|007CO023ZE|COPAB|EDI|000|AD141/546500/260405|24.20||AD141/546500/260405|EDI|EXPRESS|2020-09-18||0|AD141|3|SARL RUNGOAT|LE HENAFF||Lotissement Ker Heb Ano|sur la route entre Irvillac et le|29460|IRVILLAC||02 98 85 07 60|06 76 19 93 98|0|007|Produit|701189|770314018||FORET METAUX HSS-G DIN 338 D.3MM|20.000|UN|20.000|U |0.53|10.60|0||||||||0|||||||009449
546500|2020-09-18 11:26:25|CO023|007CO023ZE|COPAB|EDI|000|AD141/546500/260405|24.20||AD141/546500/260405|EDI|EXPRESS|2020-09-18||0|AD141|3|SARL RUNGOAT|LE HENAFF||Lotissement Ker Heb Ano|sur la route entre Irvillac et le|29460|IRVILLAC||02 98 85 07 60|06 76 19 93 98|0|009|Produit|701190|770314022||FORET METAUX HSS-G DIN 338 D.4MM|20.000|UN|20.000|U |0.68|13.60|0||||||||0|||||||009449
therefore i should catch the values in Noliv_Other csv file that corresponding at the line of AD141 user account :
NOCLI|NOLIV|ADRESSE_LIVRAISON_NOM|ADRESSE_LIVRAISON_PRENOM|ADRESSE_LIVRAISON_ADRESSE|ADRESSE_LIVRAISON_ADRESSE_COMPLEMENTAIRE|ADRESSE_LIVRAISON_CODE_POSTAL|ADRESSE_LIVRAISON_VILLE_NOM|ADRESSE_LIVRAISON_TELEPHONE|ADRESSE_LIVRAISON_PORTABLE
AD141|000001|SARL RUNGOAT|ATELIER RUNGOAT||ZA DE LOGUELLOU|29800|PENCRAN|02 98 85 07 60|06 76 19 93 98
I should have "ATELIER RUNGOAT" instead of "LE HENAFF" but there is nothing faro AD141, as show below :
Démarrage du job CdeUabRubisEolas_02 a 16:22 23/11/2020.
[statistics] connecting to socket on port 3776
[statistics] connected
AD141|
AD141|
AD155|ATELIER JAOUEN PATRICK
AD155|ATELIER JAOUEN PATRICK
AP225|ATELIER BRITTON
AD155|ATELIER JAOUEN PATRICK
[statistics] disconnected
Job CdeUabRubisEolas_02 terminé à 16:22 23/11/2020. [Code sortie=0]
Help me please !!!
It's ok, i found how to do what i needed.
But now, i can't catch a context value from subJob to put in file name generated in output.
However i can display it with a tJavaRow component but not with tJava. I understood that my tMap returned more than one value this is why the tJavaRow works and the tJava don't.
I tried to put the value that i need in a subJob context but i don't know how to retrieve it in main job. Is ther any way to do that ?
My subJob context is set like that :
And i tried to retrieved my subJob context like that :
Thanks in advance.