Help with lookup from at times empty tHash.

[MAnywar]

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.

[MAnywar · Accepted solution]

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

After deactivating the filters. all is working as expected.

[Anonymous]

Hello,

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

Best regards

Sabrina