Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Gadje
Contributor III
Contributor III

Problem with null value in tMap

Hi,

I have a problem with a returned value in tMap.

My job looks like that :

0693p00000AZKX7AAP.jpg 

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 :

0693p00000AZKX2AAP.jpg 

The expression in my tMap for check null value is like that :

0693p00000AZKUnAAP.jpg

Labels (2)
3 Replies
Anonymous
Not applicable

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

 

Gadje
Contributor III
Contributor III
Author

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 :

0693p00000AZVVMAA5.jpgMy tMap is like that :

0693p00000AZVZnAAP.jpgI 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 !!!

 

 

 

Gadje
Contributor III
Contributor III
Author

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 :

0693p00000AZcNtAAL.jpg 

And i tried to retrieved my subJob context like that :

0693p00000AZcO3AAL.jpg 

Thanks in advance.