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

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download