Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-19254

XML Output step: "Null" under fields tab is not working as expected

    XMLWordPrintable

    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:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Steps to Reproduce:
      Hide

      Steps to replicate the issue:

      1. Use Pentaho Spoon 8.3 or 9.1
      2. Open the attached transformation and execute. CCL-PDI-S068001-070-L.ktr
      3. Execute the transformation
      Show
      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

        PractiTest Integration




          Attachments

          1. CCL-PDI-S068001-070-L.ktr
            16 kB
          2. Empty.PNG
            Empty.PNG
            28 kB
          3. Null.PNG
            Null.PNG
            26 kB
          4. test.PNG
            test.PNG
            23 kB
          5. test.xml
            0.1 kB

            Activity

              People

              Assignee:
              robert_howell Robert Howell
              Reporter:
              mohshaik Mohamed Mujahid Shaik
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: