I have a java program, per exemple, who have the snippet code below :
String result = "bill;date;amount
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
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...
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.