How to send tAdvancedFileOutputXML output to tXLST without saving it

[LDR]

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 

[Dave_Simo · Accepted solution]

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-x...

Best Regards

[Dave_Simo]

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-hierarc...

Best regards