Get the total count of the output of tMap(expression filter) to use in the following tMap component

[Anonymous]

Hi,

How to pass the row count of tMap output to another tMap for hashcode mapping?

row1: I am reading a file using tFileInputExcel_1.

rowY and rowN: Using tMap expression filter, I am splitting input into 2 datasets based on the input field value('Y' or 'N')

row2: I have connected a tFlowMeter to get the count of the rowY

row3: Is the output of tFlowMeterCatcher.

I have connected tFlowMeterCatcher to tJavaRow component where I have assigned row3.count to globalMap table as below:

 globalMap.put("cnt_rowY", row3.count);

Now from tFlowMeter I have connected a tMap component to get the value of globalMap.get("cnt_rowY")

But this always gives me null.

I wanted the mod of : ((key.hashCode() & 0x7fffffff) % cnt_rowY). 

How can I achieve this.

Thanks

[Anonymous]

Hi,

     Could you please share a screen shot of your job flow for better understanding of the scenario?

Warm Regards,

Nikhil Thampi

[Anonymous]

Hi Nikil,

Thank you for responding.

After a long search in google I came to know that splitting the input dataset into 2 datasets, apply transformations and union the 2 datasets into 1 dataset(diamond flow) is not supported in Talend.

Could you kindly confirm if my understanding is correct.

If not, I would create a flow and attach it.

Thank you