If I use the Map Data task to convert an XML file to a CSV file and there are empty values in the XML, no output is written.
For example:Consider this as the XML: <element1>text1</element1> <element2></element2> <element3>text3</element3> It should result in this CSV: text1,,text3
The XPath query for element2 can be written as follows:
string(/xml/element2/text())rather than /xml/element2/text()
This will convert the empty value to a string, which is allowed to run this task.
Automation Engine 14.x and newer
It works perfectly fine but not repeated content, do you have an idea?
Note: This is an anonymous survey. If you need help from Esko Support, register a Support Case here.