It appears that there is no choice for row separator in tAdvancedFileOutputXML. The output file is generated with LF as row separator. I could find no choice in the component, and some older posts (2015) point in the same direction.
Is there any choice other than replacing LF with CRLF in an editor (e.g. notepad++)?
Did you set any root tag in your tAdvancedFileOutputXML? Screenshot of how to configure your XML file will be preferred.
Perhaps you could read your xml file withe tFileInputFullRow component then replace LF with CRLF in a tMap component.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
This video will show you how to add context parameters to a job in Talend Cloud
This video will show you how to run a job in Studio and then publish that job to Talend Cloud
This video will help someone new to using Talend Studio get started by connecting to Talend Cloud and fetching the Studio License