Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Excel data files and String conversion

  1. #1

    Default Excel data files and String conversion

    I have a column which is text in excel containing text, numbers and dates. When i import the excel file in data integrator and mask the column by using "#" in the fields tab my date fields for that column get the '#' value. Cannot have that happen.
    How do i get the correct values from excel to display in the data integrator ? is there an element i got to use which will enable me to get the right values from excel to ETL?

    Thanks

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Please, post a sample Excel file and a transformation with an Excel Input step configured to show your problem.
    So long, and thanks for all the fish.

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.