How to read java program AS a extract talend

[Anonymous]

Hello,

I have a java program, per exemple, who have the snippet code below :

 {

String result = "bill;date;amount

A21;201707;20.00

A22;201707;27.09";

return result;

}

In Talend, i can copy/paste this "snippet" and make a talend routine.

But i want to set the routine as a input and read the result like an input.. How ?

For exemple :

Job Talend :

1) My input : Execute the routine and extract result.

2) tLogRow will read 3 rows :

row 1 : bill;date;amount

row 2 : A21;201707;20.00

row 3 : A22;201707;27.09

If routines is not possible, i can make a .jar program, but in same idea, how talend can read it ?

Thanks for help

[Anonymous]

If I understand your requirement you can achieve it by using a tJavaFlex to start your job. In the "Start Code" you would call your third party code and get the result. Then you can split it into rows using the "Main Code" section.

A simple example of how you can use a tJavaFlex (not related to this requirement, just an example of the tJavaFlex) can be found here...

https://www.rilhia.com/quicktips/quick-tip-row-multiplication

[Anonymous · Accepted solution]

Hi !

You can do it like this :

1) In your tRowGenerator, call you routine to store the result in your column. (take care : use a \n to pass a line)

2) tNormalize settings : use \n to separate element.

Good luck

SGV