Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data in tabular format, and for that data, I want to create XML here I am sharing XML structure, in that XML I want to create multiple XML based on The Account Element for every Account I want to create a separate XML to send on FTP
@Not defined Not defined
I think you need two steps to achieve this requirement.
1, Read the data from source file line by line and output each line to different output file for each account. eg:
tFileInputDelimited--main(row1)--tFlowToIterate--iterate--tFixedFlowInput--tFileOutputDelimited
tFixedFlowInput: generate the current data
Set a dynamic output file path on tFileOutputDelimited, eg:
"D:/file/"+(String)globalMap.get("row1.account_column_name")+".txt"
2, Iterate each account file and create corresponding XML file for each account. eg:
tFileList--iterate--tFileInputDelimited--main--tAdvancedFileOutputXML--oncomponentok--tFTPPut
Can you try and let me know if you have any questions
Regards
Shong