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

Excel Input Step is padding .0 to the string column

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Severity: Low
    • Resolution: Unresolved
    • Affects Version/s: 4.1.2.1 GA (Platform 3.8.0)
    • Fix Version/s: Backlog
    • Component/s: Step
    • Labels:
      None
    • 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.

      Description

      Trying to load a data from an .xls file using Excel input Step and In the spreadsheet if a a column has with alphanumeric and numeric content.
      The alphanumeric content is treated as a string. But the numeric content in the column is append with .0 and loading into the database

      Example:
      ("string" like 1100 get changed to 1100.0).

      We have changed the metadata of the column to string before "Table Output"

      Steps to reproduce:

      1. Please find the attached transformation.
      2. Add the xls file to the Excel input step.
      3. Take preview in the select values which will show .0 appended to the numeric value.

        Attachments

        1. sample.ktr
          19 kB
        2. sample.png
          sample.png
          62 kB
        3. sample.xls
          7 kB

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                vikramns Vikram NS
              • Votes:
                11 Vote for this issue
                Watchers:
                14 Start watching this issue

                Dates

                • Created:
                  Updated: