Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Bug :Generate Mapping

  1. #1
    Join Date
    Nov 2007
    Posts
    14

    Default Bug :Generate Mapping

    Dear all

    my process goes here

    1.read value from a excel file(Three sheet excel file)
    2.load the 3 sheet data to the diferent three table in mysql
    3.finsh

    to do the above job i used mapping between excel input and table output

    but the problem is mapping step is can't filter the mapped data.

    i have 9 column from excel and i only select 3 column for the mysql table output. but kettle transfer rest of the 6 columns value with 3 selected columns in the newly created table.but i only selected 3 columns .

    i tried and tried. but i couldn't find any clue. in the designer when i select the mapping step and find its output. it shows only 3 column as output.but when i run the transformation it goes wrong.

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    For testing purposes replace your table output with a text output using the same kind of fields. If you can get the correct number of fields at the text output step reintroduce the table output.

    And maybe attach your transformation to this thread.

    Regards,
    Sven

  3. #3
    Join Date
    Nov 2007
    Posts
    14

    Default Bug:Excel Input

    i did the same thing for the text file output. it shows the same thing. anyway what is the function of start row and start column

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    Start row and start column is where the step will begin reading from in excel (so you can skip some rows and some starting columns).

    The easiest to get your problem fixed is to attach your transformation (using files, not table outputs) and some Excel input file so that we can test a bit.

    Regards,
    Sven

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.