Help with lookup from at times empty tHash.

MAnywar — Fri, 15 Nov 2024 22:25:33 GMT

I have tried to make some adjustments;

But now i feel like I have another issue:

I am reading from a pipeline that at times send me data that I need to disregard; at times I have to read and process (Filter)

But now I have an issue where by I have to create a join to form one xml document based on the data in the tHash output. However, at times tHashOutput 6 contains null as the data going in it was filtered out (not needed). This causes my job to keep breaking due to the fact that The hash 1 keeps complaining that it is not initialized. It is really getting frustrating. I have tried most possible options including redesign, but and all filtering, but none seems to work for me.

Please if you can advise me on how to go about this, I will surely be grateful.

tMap1 has some formatings it is doing on both arms and then tmap2 is joing the two. But tHashInput_2 always has data. it is input1 that at times contains nulls.

Re: Help with lookup from at times empty tHash.

MAnywar — Tue, 25 Oct 2022 20:06:59 GMT

I solved it. My tFilters were the ones causing problems.

After deactivating the filters. all is working as expected.

Re: Help with lookup from at times empty tHash.

Anonymous — Fri, 28 Oct 2022 09:34:50 GMT

Hello,

Thanks for letting us know you have resolved it and sharing the root cause with us on Community.

Best regards

Sabrina

topic Help with lookup from at times empty tHash. in Talend Studio

Help with lookup from at times empty tHash.

Re: Help with lookup from at times empty tHash.

Re: Help with lookup from at times empty tHash.