Using Talend Open Studio for Data integration How can I split one Excel file into multiple outputs based on values of given column ? Example Example of data in input.xlsx : ID; Category 1;...
There are 2 problems with your approach. First, tExtractJSONFields doesn't support passthrough of fields (codeObjetStart, codeRetour, libelleCodeErreur, versionObjetStart). If it did support it, you wouldn't have to set a jsonpath expression for each of these fields, because you already read them in your tFileInputJSON. That brings us to the 2nd problem which is that jsonpath doesn't support ...
Just to benefit others, with recent release of Talend, they have removed the User libraries. We need to use the Modules to see, download or install new libraries. We can add Modules view by going to Window -> Show view -> Talend -> Modules. From the Modules section we can manage all the external libraries.
for any talend component look under outline tab under the left side workspace pane at the bottom. this lists down the properties available via global variables for that component. Some properties like count of records inserted by output components are only available once the component is executed completely (After). for your case you can try directly using ( (Integer)globalMap.get ...
Talend - Exception in thread "main" java.lang.Error: Unresolved compilation problems: The import routines cannot be resolved Asked 5 years, 2 months ago Modified 1 year, 1 month ago Viewed 6k times
Talend output components have a global variable called NB_LINE which you can use to get the number of rows written to the component's file or table. In your case you can use tFileOutputExcel's variable: (Integer)globalMap.get ("tFileOutputExcel_1_NB_LINE") Note that this is an "after" variable which is available after the file has been written, so you can get it using an OnComponentOk or ...
