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

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

qlikviewwizard — Thu, 11 Dec 2025 18:22:52 GMT

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

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

qlikviewwizard — Fri, 12 Dec 2025 12:44:22 GMT

Hi All,

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

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

qlikviewwizard — Tue, 16 Dec 2025 08:16:03 GMT

Hi All, Is there any solution? Thanks in advance

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

Shicong_Hong — Tue, 16 Dec 2025 08:50:14 GMT

@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

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

qlikviewwizard — Thu, 18 Dec 2025 07:54:15 GMT

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?

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

Shicong_Hong — Tue, 30 Dec 2025 05:36:55 GMT

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.

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

qlikviewwizard — Tue, 06 Jan 2026 12:58:53 GMT

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

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

Shicong_Hong — Thu, 08 Jan 2026 05:52:32 GMT

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

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

qlikviewwizard — Thu, 08 Jan 2026 10:13:47 GMT

Hi @Shicong_Hong ,

Please find the attached image

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

Shicong_Hong — Tue, 13 Jan 2026 07:11:57 GMT

@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?