Getting null values while generating an xml

[sbhadra]

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

[sbhadra]

Hi Team,

Any suggestion on the same

[corentin1]

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)