Read XML file

[gtaware]

Hi Team,

Can please help me to read attached XML ?

[Anonymous]

Hi
It is a simple XML file, not difficult to read data from it, which data do you want to extract?
As a newbie, you can create a XML metadata following the wizards in Repository-->Metadata-->FileXML, then, drag and drop the XML metadata you just created to a job, and select tFileInputXML component to read it.

Regards
Shong

[gtaware]

Thanks Shong . I tried it and  I am able to read a data when I click on Refresh Preview . 

I have used Xpath Loop Expression as : @id , @extid and Payment Type .. But when I am using tInputXML then it is throwing me error as : 

[statistics] connecting to socket on port 3964
[statistics] connected
Unparseable date: "1-800-81-3399"
[statistics] disconnected

[Anonymous · Accepted solution]

check the data type of phoneNumber column on the schema, it seems you are reading this column with Date type, if so, change it to string type.

[gtaware]

Thanks Its Worked.