Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

Talend Cursor Equivalent Tool

Highlighted
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
Highlighted
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.

View solution in original post


All Replies
Highlighted
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.

View solution in original post

Highlighted
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?

Highlighted
Eight Stars

Re: Talend Cursor Equivalent Tool

Variable Ports

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog