tXMLMap trowing Unparseable date: "2008-08-01T13:38:27.133"

[brunosimoes]

Hello,

I am trying to parse a XML File to another format to get rid of the XML Overhead. A smaller sample of the file is attached with the name "Posts_Metadata.xml".

I created a metadata process connecting to a tInputXML, that connect to to a tLogRow to test the output before trying to write it and started getting the Unparseable date: "2008-08-01T13:38:27.133". I am trying to connect it now using a tXMLMap to parse the date, but I don't know how to do it. Can anyone please intruct me on what I could do to make this job work?

[Anonymous · Accepted solution]

Hi

The date pattern used to parse the date does not map the date format like "2008-08-01T13:38:27.133", change the date pattern of Date column to "yyyy-MM-dd'T'HH:mm:ss.SSS"

Regards

Shong

[brunosimoes]

It worked, thanks.