You are not logged in.
i have job which get vendor numbers from SQL tables. after that we are creating a file for each vendor number. files created successfully but some of files has no name. even it is not created for last or first file it is created in the middle of vendor numbers.
due to some restriction i can not show exact schema but here is deep explanation it.
in Tflowtoitrate we are storing value of vendor number (all integer values) in the variable vVendorNumber
which is latter upended to tFileOutputDelimited file path.
file is created with proper data but name is not there.
file names looks like
Don't know how do you set the file name of tFileoutput, according to your description, it should be a dynamic file path here, for example:
//vendor is one of the column name on SQLInput.
I think here is a empty value from the table, that's why you get a file name looks like:
For debug, add a tJava component and print the global variable before using it. for example:
System.out.println("The value of vendor column is:"+(Integer)globalMap.get("row1.vendor"));