topic Re: Talend Cursor Equivalent Tool in Talend Studio

Talend Cursor Equivalent Tool

Anonymous — Sat, 24 Mar 2018 02:14:51 GMT

What is the SQL Cursor equivalent Tool in Talend?

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

Re: Talend Cursor Equivalent Tool

ashif2 — Sat, 24 Mar 2018 10:53:48 GMT

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.

Re: Talend Cursor Equivalent Tool

Anonymous — Sat, 05 May 2018 04:30:06 GMT

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?

Re: Talend Cursor Equivalent Tool

ashif2 — Tue, 08 May 2018 14:49:45 GMT

Variable Ports