Details
-
Type:
Bug
-
Status: Open
-
Severity:
Unknown
-
Resolution: Unresolved
-
Affects Version/s: 8.3.0 GA, 9.1.0 GA
-
Fix Version/s: None
-
Component/s: Step
-
Labels:None
-
Environment:Windows and Linux
-
Story Points:0
-
PDI Sub-component:
-
Notice:
-
Steps to Reproduce:
Steps to replicate the issue:
- Use Pentaho Spoon 8.3 or 9.1
- Open the attached transformation and execute. CCL-PDI-S068001-070-L.ktr
- Execute the transformation
Description
The transformation with XML Output step having the "Null" under the "Fields" tab is not working as expected. When we specify a string value in NULL section under Fields tab, the null value in the stream is not getting replaced with the STRING value provided.
Not passing any String value in the Generate rows step.
Passing the String value in the "Null" under the "Fields" tab in the XML Output step. But null is not getting replaced with the String values.
Actual result
The value of the element name "data1" was not replaced, and the output was as follows.
<?xml version='1.0' encoding='UTF-8'?>
<Rows>
<Row><data1/></Row>
</Rows>
Expected Result
The value of the element name "data1" is replaced and the output is as follows.
<?xml version='1.0' encoding='UTF-8'?>
<Rows>
<Row><data1>ABCD</data1></Row>
</Rows>
Attaching the CCL-PDI-S067601-106-L transformation, test.xml file. However, the same option works fine with Text File Output step. We have even tried setting the below property in kettle.properties, but there was no change in the behavior,
KETTLE_COMPATIBILITY_XML_OUTPUT_NULL_VALUES=Y
