Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team
I am using an Oracle DB to fetch few records out of which two details Order No and Order Line No which is getting pulled needs to be used to give the give the generated file name
like Order No - 12345 Order Line No - 234578
So the generated xml file Order_12345_234578.xml. However, every time it is generating Order_null_null.xml. I tried to save the same in globalMap still it is giving me the same output.
The flow is like this
tOracleConnection->tOracleInput->tMap->tAdvancedFileOutputXML
Hi Team,
Any suggestion on the same
you won't be able to set the filename with data retrieved from within the same flow. (either with global variables or with fields from your flow).
You could do it with 2 subjobs : one will read data from oracle and put it in cache/file ; the other one to read data from cache/file to your XML output file.
1) tOracleInput>tHashOutput>oncomponentOK>tjava (set your global variables there)
2) (with onsubjob OK link) : tHashInput>tMap>tAdvancedFileOutputXML (use global variables in xml component)