Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Replace NULL Value Excel

  1. #1
    Join Date
    May 2017
    Posts
    2

    Question Replace NULL Value Excel

    Hi,

    I'm new in Pentaho Data Integration, I need a help, I have a Excel with 3 field: id, name & last. I need extract all information but need validate if the id field is null replace with a sequence.

    I try to use Filter Rows and separate the Rows with null id and without null id but I don't what step need to replace the null id with the sequence.

    Thanks for your help.

    Best Regards,
    Christhian Chamba.

  2. #2
    Join Date
    May 2016
    Posts
    282

    Default

    I miss some information in your post about the logic the sequence needs to meet:
    - Is there a database sequence in any place?
    - Do you need to read the Excel file to find the max Id and then generate a sequence for the null values using MaxId + 1?
    - Do you have the values for sequence in any other place?
    OS: Ubuntu 16.04 64 bits
    Java: Openjdk 1.8.0_131
    Pentaho 6.1 CE

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.