Extracting of records from a xml file

[Soumya_M]

Hello,

I need to extract a xml file in talend, but in a particular level, there are multiple records which isn't getting reflected in postgres table.

Could someone help me with this issue? for reference I've attached pic

[Anonymous]

Hi

tFileInputXML component is used to extract data from a XML file, as a newbie, go to Repository-->Metadata-->File XML, follows the wizards to create a XML metadata. After you create the XML metadata, you can import the component configurations from repository instead of configuring the settings manually on tFileInputXML.

Let me know if you have any issues.

Regards

Shong

[Soumya_M]

Hi Shong,

I tried extracting under FileXML wizard, I couldn't extract it

I'm getting the same column twice in schema preview.

[Soumya_M]

How to extract the multiple values which are present under ssCode and ssTime?

[Anonymous]

Hi

From your screenshot, I see you are able to extract all records under SuppServiceUsed element. About the same column twice in the schema preview, remove the columns you don't want from the 'Fields to extract' table, then click the 'preview' button again.

Regards

Shong

[Soumya_M]

It didn't help much. Yet to figure out a way to extract multiple values

[Anonymous]

Can you share a screenshot of Field to extract table? I still think it's a configuration issue.

 

[Soumya_M]

Here it is..

[Soumya_M]

Hi Shong , I want output with columns - ssCode, ssTime, ssCode1, ssTime1.

11 under ssCode, 2A under ssCode1