Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Import XML file to SQL database

I have an XML script and I want to insert those data into an SQL table.

XML Script is attached.

This is what I have tried so far.

0683p000009M929.pngJob

Actual Output:

0683p000009M9Db.pngActualOutput

Expected Output: I want those XML data to be displayed in a tabular Table, e.g:

 

0683p000009M9PC.pngDummyData

I'm completely new to talend and don't know how to proceed.

 

Labels (4)
3 Replies
manodwhb
Champion II
Champion II

In the tLogRow, is it printing as expected? After tlogrow you can connect to tdboutput component and chose the your db type.
Anonymous
Not applicable
Author

tlogRow is not printing as expected.

 

0683p000009M9B1.pngOutput

Output In tLogRow:

 

0683p000009M99t.pngtLogRowOutput

manodwhb
Champion II
Champion II

@PraKan1605, you might have not configured tXmlMap as you need the output way.