How ArrayIndexing for tMemorizeRow work in talend

Highlighted
Five Stars

How ArrayIndexing for tMemorizeRow work in talend

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


Accepted Solutions
Employee

Re: How ArrayIndexing for tMemorizeRow work in talend

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 :-)

View solution in original post


All Replies
Employee

Re: How ArrayIndexing for tMemorizeRow work in talend

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 :-)

View solution in original post

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

An API-First Approach to Modernizing Applications

Learn how to use an API-First Approach to Modernize your Applications

Watch Now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read