Talend Cursor Equivalent Tool

Five Stars

Talend Cursor Equivalent Tool

What is the SQL Cursor equivalent Tool in Talend?

 

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


Accepted Solutions
Eight Stars

Re: Talend Cursor Equivalent Tool

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.


All Replies
Eight Stars

Re: Talend Cursor Equivalent Tool

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.

Five Stars

Re: Talend Cursor Equivalent Tool

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?

Eight Stars

Re: Talend Cursor Equivalent Tool

Variable Ports