topic How to read java program AS a extract talend in Talend Studio

How to read java program AS a extract talend

Anonymous — Thu, 07 Sep 2017 10:16:11 GMT

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

Re: How to read java program AS a extract talend

Anonymous — Thu, 07 Sep 2017 11:55:56 GMT

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

Re: How to read java program AS a extract talend

Anonymous — Thu, 07 Sep 2017 12:08:34 GMT

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