How ArrayIndexing for tMemorizeRow work in talend

[shameer1]

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

[Anonymous · Accepted solution]

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 🙂