Talend Cursor Equivalent Tool

[Anonymous]

What is the SQL Cursor equivalent Tool in Talend?

Like the Multi Row Formula Tool in Alteryx, for example?

[ashif2 · Accepted solution]

Talend gives the variable ports in tmap to do multi row operation.

Here in the new example , New Field Transaction Group is generated based on Name field (Based on the value "Transcation" new field is assigned ). This kind of assignment and logic can be achieved by using variables in tMap 

Name	Value	New Field: Transaction Group
Transaction	2770	1
TMC	2	1
JAG	3	1
DLS	6	1
LMD	8	1
DM	9	1
ZB	7	1
Transaction	2771	2
JAG	3	2
DLS	4	2
ZB	9	2
Transaction	2773	3
TMC	5	3
ZB	7	3
DM	9	3

Click Apply to have the configurations accepted.

[Anonymous]

I'm sorry, can you specify what is the name of the command to perform Multi-Row operations in tMap? I can't find it anywhere.

Also, I need to perform Multi-Field operations, is there a command for this?

[ashif2]

Variable Ports