How ArrayIndexing for tMemorizeRow work in talend

shameer1 — Sat, 16 Nov 2024 06:01:05 GMT

Suppose i have input data as below :-

Emp_id|Name|Month|Salary

101|Shameer|01|1000

101|Shameer|02|2000

101|Shameer|03|3000

101|Shameer|04|4000

101|Shameer|05|5000

Below is my flow :-

tFileInputDelimited->tSortRow->tMemorizeRows->tMap->tLogRow

in tSortRow component -> we are sorting the record on column Emp_id and Month in ascending order

then tMemorizeRows below are the properties->

row count to memorize->3

columns to memorize -> Emp_id

so My question is what will be the value of below global variable for tMemorizeRow component

for below 3 scenarios:-

1:- When i am fetching first record (101|Shameer|01|1000)

(((Integer[])globalMap.get("tMemorizeRows_Emp_id"))[0])

(((Integer[])globalMap.get("tMemorizeRows_Emp_id"))[1])

(((Integer[])globalMap.get("tMemorizeRows_Emp_id"))[2])

2:- When i am fetching second record (101|Shameer|02|2000)

(((Integer[])globalMap.get("tMemorizeRows_Emp_id"))[0])

(((Integer[])globalMap.get("tMemorizeRows_Emp_id"))[1])

(((Integer[])globalMap.get("tMemorizeRows_Emp_id"))[2])

3:- When i am fetching Third record (101|Shameer|03|3000)

(((Integer[])globalMap.get("tMemorizeRows_Emp_id"))[0])

(((Integer[])globalMap.get("tMemorizeRows_Emp_id"))[1])

(((Integer[])globalMap.get("tMemorizeRows_Emp_id"))[2])

4:- When i am fetching Third record (101|Shameer|04|4000)

(((Integer[])globalMap.get("tMemorizeRows_Emp_id"))[0])

(((Integer[])globalMap.get("tMemorizeRows_Emp_id"))[1])

(((Integer[])globalMap.get("tMemorizeRows_Emp_id"))[2])

Above four scenarios will help me know how the Array for the memorized columns are assigned.

Thanks

Shameer

Re: How ArrayIndexing for tMemorizeRow work in talend

Anonymous — Wed, 24 Apr 2019 07:21:31 GMT

Hi Shameer,

I would recommend to try the below scenario mentioned for the component in the help document to see the results yourself.

https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/BhKFvhAJHOci6KUzllNgvA

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

topic How ArrayIndexing for tMemorizeRow work in talend in Talend Studio

How ArrayIndexing for tMemorizeRow work in talend

Re: How ArrayIndexing for tMemorizeRow work in talend