Problem with null value in tMap

Gadje — Fri, 20 Nov 2020 13:14:02 GMT

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 :

Re: Problem with null value in tMap

Anonymous — Mon, 23 Nov 2020 03:21:24 GMT

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

Re: Problem with null value in tMap

Gadje — Mon, 23 Nov 2020 15:49:02 GMT

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) :

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 :

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|

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 !!!

Re: Problem with null value in tMap

Gadje — Tue, 24 Nov 2020 10:38:33 GMT

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.

topic Problem with null value in tMap in Talend Studio

Problem with null value in tMap

Re: Problem with null value in tMap

Re: Problem with null value in tMap

Re: Problem with null value in tMap