How to read an XML

CloverDX Platform
1

Hi,
i am new in CloverETL, so maybe my problem is no so complicated:

I am trying to read an xml like that:

8J/7N - LE MANSOUR EDDAHBI 5\* <!\[CDATA\[\> <!\[CDATA\[\> 489 <!\[CDATA\[ L'hôtel est situé au cour de Marrakech, à quelques minutes de la célèbre place Jemaa el Fna et des principaux monuments historiques de la ville.L'aéroport se trouve à 5 km. Taxis et navettes (payants).

]]>










using:

but, surprise, i cannot read the fields “formule”, “ville”, “pays”, “arrivee”, “duree”, …

Any ideas??

Thanks!

2

Hi,

I’m afraid it is not possible from XMLExtract directly. You can transform your xml file by xslt (ie. name=“ville” Value=“NANCY” ->> ville=“NANCY”) and then you can use XMLExtract. There exists one more quite complicated solution. If you use something like

you get list of records about one product and then you can use reformat component to aggregating products (java code in tranform method)… but last product. You get this one when sent some other record to reformat component after it.