topic How to send tAdvancedFileOutputXML output to tXLST without saving it in Talend Studio

How to send tAdvancedFileOutputXML output to tXLST without saving it

LDR — Tue, 15 Jul 2025 07:04:56 GMT

Hi everyone,

First at all thanks for your help 😉

I'm developing one job that contains the following steps:

1- tFileInputPositional --> it works fine, I mean, it reads my txt file and for each row extract different columns based on the positions and lenghts I set.

The result has to be converted to XML for doing that I tried several objects: tXMLMap or tAdvancedFileOutputXML.

With tXMLMap I was able to obtain the result I want but I have to save it in a xml file. Finally I decided to avoid using it.
With tAdvancedFileOutputXML I can create the desired XML document on the fly but I don't know how to send the result to the next component (tXSLT) to transform it. I'm still working on it.

So I don't know if I'm using the right component because like I mentioned, I don't see the way to send the result of tAdvancedFileOutputXML to tXSLT.

In summary my job should be: tFileInputPositional --> tAdvancedFileOutputXML --> tXLST --> tSAPIDOCOutput

Any idea, suggestion about how to proceed?

PS: I'm using Talend Studio 8 (20250704_1436-patch)

Thanks

Re: How to send tAdvancedFileOutputXML output to tXLST without saving it

Dave_Simo — Wed, 16 Jul 2025 08:35:34 GMT

Hello @LDR

I used the tXSLT component as below with a stylesheet to be applied to my upstream generated xml.

You can find in the Qlik/Talend documentation how to use this component

https://help.qlik.com/talend/fr-FR/components/8.0/xml/txslt-tmsgbox-transforming-xml-to-html-using-xsl-stylesheet-standard-component

Best Regards

Re: How to send tAdvancedFileOutputXML output to tXLST without saving it

Dave_Simo — Wed, 16 Jul 2025 08:47:09 GMT

Hello @LDR

However, if you want to use a tSAPIDOCOutput to send this Idoc to SAP, you should instead use a tHmap (because it allows you to convert XML to IDOC or JSON, etc.)

You can watch this tutorial on how to use tHmap

https://japprendslabi.fr/talend/talend-cloud-data-integration/utilisation-talend-data-mapper-hierarchies-boucles/

Best regards