How to split Excel source into Products, Customers, and Sales tables and export as XML in Talend 8?

[qlikviewwizard]

Hi Folks,

We are using Qlik Talend Cloud Enterprise Edition v8 (Build id: 20250521_1150-patch).

I have an Excel file (C:\Source\Source_Data.xlsx) with Sales, Customers, Products info in a single excel sheet.
I need to:

• Load this file into a template with Products, Customers, and Sales tables.
• Export the final output as XML to C:\Target\ABC_Sales_Info.xml.

Has anyone done this in Talend 8?
What is the best way to split the data and create the XML structure?
Any sample job design or steps would be helpful.

Source data in excel :

Target data in XML in 3 sheets :

Customers:

CustomerID CustomerName Email Phone City Country 201 Alice Johnson alice.johnson@example.com +1-202-555-0147 New York USA 202 Bob Smith bob.smith@example.com +1-202-555-0178 Los Angeles USA

Products:

ProductID ProductName Category Price StockQty Supplier 101 Laptop Pro 15 Electronics 1200 50 TechWorld Inc. 102 Wireless Mouse Accessories 25.99 200 GadgetSupply Co.

Sales:

SalesID OrderDate CustomerID ProductID Quantity UnitPrice TotalAmount 1001 1/5/2025 201 101 2 1200 2400 1002 1/12/2025 202 109 3 45 135

[qlikviewwizard]

Hi All,

Could you let me know anyone has worked on this scenario?

[qlikviewwizard]

Hi All, Is there any solution? Thanks in advance

[Shicong_Hong]

@qlikviewwizard 

Is the example file "Sales domain data.csv" in the same data format as your "Source_Data.xlsx"? If so, you can simply use a tFileInputExcel to read these data from the Excel file and then split these data into 3 output tables on tMap.

Regards

Shicong

[qlikviewwizard]

Hi @Shicong_Hong ,

Thanks for the reply.I am using simple CSV as one source to explain my scenario.

I have followed the same. Unfortynately second dataset is replacing prior data. For example if I load Products first then second load Sales data is replacing Products.

How to select the option settings at Target compoent?

[Shicong_Hong]

Hi @qlikviewwizard can you please share a screenshot of your job to show us what are you doing to load the dataset? If you are using tMap to filter the columns, you need to create 3 different output tables. 

[qlikviewwizard]

Hi @Shicong_Hong ,

This is the job and components are using. Please advise.

Please help me provide the solution when we have 2 tabs in XML output file

[Shicong_Hong]

Sorry, your image is too small to view. Please upload it again.

[qlikviewwizard]

Hi @Shicong_Hong ,

Please find the attached image

[Shicong_Hong]

@qlikviewwizard Thank you! Could you please share a screenshot of the tXMLMap component as well? I'd like to see the input/output schema configuration. Additionally, could you please show us your current output result and your expected result?