Dynamic Schema for Mapping in tMap

[Anonymous]

Hi, I have an XML file which I receive on daily basis but the schema is given as follow,

C1

C2

C3, where the value of C1, C2, C3 fluctuates it can be one of {Location, Date, and Confirmation Number}.

Example of raw file of different date shared below.

I need to map these fluctuations on a dynamic basis, please have a look at below screenshot `tMap`.

How can I achieve this? Please help.

Thanks, 

Meet

[Anonymous]

Hi @nthampi

 It seems like inappropriate solution what if there are so many strings like
if C-numbering has attributes like Arrival Date, Departure Date, Name, Location, and Address.

Java Code will rectify date as per your solution but what about the date of type(arrival or departure)?
The java code will interpret ALPHANUMERIC, but is it a NAME or ADDRESS or LOCATION?

Please let me know if it makes sense.

Thanks 

Meet

[Anonymous]

Hi Meet,

     You are right since lot of additional computation power will be needed since your XML is not having a proper structure.

     I would say you are just seeing the tip of the ice berg. There are lot of finer aspects like understanding first name and last name, standardization of name, address etc. I recommendation always is to create XML flows based on an agreed XSD patterns between source systems and target systems.

     In today's world, you can still parse the data whatever may be the format using machine learning models and all those stuff. But the question is how much you are ready to invest in data parsing and how much resources are available for you from system perspective. 

      The most easy way is to create an interface document using XSD which is agreed by your source and target systems and allign the flow to those XSDs. Your required computation power will be a fraction of what you are trying to achieve now. 

Warm Regards,

Nikhil Thampi