'null' values received when using a tJavaFlex with a main flow. Fixed by using an iterate flow.

[schwarben]

I still experience troubles using tJavaFlex component. Using a main flow as an input, sometimes everything runs smoothly but there are cases when the tJavaFlex only gets null values in all fields. I managed to find a workaround by using a tFlowToIterate component to transcode the main flow in an iterate flow, but I would like to understand what is happening here.

• Why is tJavaFlex sometimes ok with main flows, and why sometimes it gets only null values ?
• Why using an iterate flow helps ?
• And finaly, I realized I don't really get what an iterate flow does and when to use it compared to a main flow.

Any explanation on any of these topics would be greatly appreciated.

Thanks !

[schwarben]

This actually was my first idea, but I didn't find how to do that. I was expecting to do that with a 'rank' operation in the tAggregateRow component to emulate the row_number() function in SQL, but there is none.

[schwarben]

Thank you ! Thank you ! Thank you !

Now I will be able to sleep !

[gjeremy1617088143]

my idea : tflowtoiterate --> iterate -->tjava with a globalMap.put (name counter type int set to 0 )--> on component ok -->rowgenerator with the globalvar of the tflowtoiterate --> main --> tnormalize --> tjavarow with a new column (named order value : counter +1 --> tjavarow (if value of counter !=1 then null for N and P)

[gjeremy1617088143]

Ps you could do the both tjavarow code in one like --> (if value of counter + 1 !=1 then null for N and P else N = N ,P =P)

[gjeremy1617088143]

so good night 🙂