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

Simple Evaluation Step: When the type is "Datetime", only the first value in the list is evaluated when success condition involves list

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Severity: Medium
    • Resolution: Unresolved
    • Affects Version/s: 8.0.0 GA, 9.0.0 GA, 8.3.0.0
    • Fix Version/s: Backlog
    • Component/s: Step
    • Labels:
      None
    • 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

      Use the attached job and transformation to replicate the issue

      Show
      Use the attached job and transformation to replicate the issue

      Description

      In the Simple Evaluation Step, when the success condition is if value in list or if value not in list and the type is Datetime, then only the first value in the list is evaluated, and the rest of the values on the list are ignored.

      Refer to the sample attached. SampleJob.zip
      In this sample, we are saving the value 2020/01/02 01:23:45.678 into the memory by using Copy rows to result. This value is then used to check if it is not present in the list using the success condition if value not in list in the Simple Evaluation step.
      The list value are 2020/01/02 01:23:45.679,2020/01/02 01:23:45.678,2021/01/02 01:23:47.678
      On executing the job the still goes to the success stream instead of Abort even though the value from the memory is present in the list.

      If we change the order of values in the list as 2020/01/02 01:23:45.678,2020/01/02 01:23:45.679,2021/01/02 01:23:47.678, the job works as expected.

      Notice that the highlighted value in red color and its position in the list.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            gdev Gurudev
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: