Issue in Creating multiple xml

TG3 — Fri, 15 Nov 2024 22:21:42 GMT

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

Re: Issue in Creating multiple xml

Anonymous — Wed, 16 Nov 2022 09:59:33 GMT

@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

topic Re: Issue in Creating multiple xml in Talend Studio

Issue in Creating multiple xml

Re: Issue in Creating multiple xml