Hitachi Vantara Pentaho Community Forums
Results 1 to 13 of 13

Thread: passing parameterto table input

  1. #1

    Default passing parameterto table input

    heey guys,
    iam using PDI 3.2
    i want to pass parameters to table input,
    i checked this

    http://forums.pentaho.org/showthread...atement+kettle

    and i made the same things

    text file input connected to table input and check on execute for each row , and insert data from step : text file input.
    the data in text file contains:

    ID
    1

    first thing : the hop between the text file input and table input has blue circle and sign ! inside it
    and telling me that :

    Rows are being sent to step [table input] so that they can be sued as additional information.
    That target step specifically reads from [text file input] and it is treated as special case.
    That means that for this source step the normal row reading rules don't apply.
    Normally a step reads information from all source steps in a round robin fashion.



    second thing : when i press the pull down menu for choosing the step "after first choosing" , it didn't show any input steps.
    third thing when i tried to preview rows in input table step i got the following :

    2009/08/24 14:31:26 - Trans - This transformation can be replayed with replay date: 2009/08/24 14:31:26
    2009/08/24 14:31:27 - Table input.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected error :
    2009/08/24 14:31:27 - Table input.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :

    org.pentaho.di.core.exception.KettleStepException:
    2009/08/24 14:31:27 - Table input.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : The source step to read from [Text file input]

    couldn't be found.
    2009/08/24 14:31:27 - Table input.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
    2009/08/24 14:31:27 - Table input.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at

    org.pentaho.di.trans.step.BaseStep.findInputRowSet(BaseStep.java:1797)
    2009/08/24 14:31:27 - Table input.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at

    org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:99)
    2009/08/24 14:31:27 - Table input.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at

    org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
    2009/08/24 14:31:27 - Table input.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at

    org.pentaho.di.trans.steps.tableinput.TableInput.run(TableInput.java:345)
    2009/08/24 14:31:27 - Table input.0 - Finished reading query, closing connection.
    2009/08/24 14:31:27 - Table input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
    2009/08/24 14:31:27 - Kettle - Transformation detected one or more steps with errors.
    2009/08/24 14:31:27 - Kettle - Transformation is killing the other steps!


    i attached the input file and the transformation to review it.
    waiting your replies , and thanks in advance

  2. #2
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    You forgot to attach the files :P

  3. #3

    Default

    aah , sorry
    Attached Files Attached Files
    Last edited by Rasha; 08-25-2009 at 07:51 AM.

  4. #4

    Default



    heey guys , am still waiting

  5. #5
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    I believe you attached a different version of the transformation than the one you described, since this one expects an XLS as input.

    Please provide the correct files so we can minimize the effort

  6. #6

    Default

    yaa , i noticed it before my last reply and i updated it

    sorry for that

    and thanks for your interest

  7. #7
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    I just added the field to the Text File Input step, and after that the transformation worked correctly.

    Cheers!

  8. #8

    Default

    what field
    i guss you forgot to attach the file

  9. #9
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    In the last tab of the Text File Input properties, "Fields", specify the field that's contained in the txt input file.

  10. #10

    Default

    ahaaa
    it works finally

    Thank you

    sorry for that , but i want to know another thing :$

    how to remove the header of data coming from table input step

    afer running the transformation, i had 1 header row , and 1 row contains data , i want only the data row without the header

    is there a way to do that ?

    thank you again

  11. #11
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    Hm... You should really take a look at the documentation before asking: http://wiki.pentaho.com/display/EAI/Text+File+Output

    Look for "Header" in the "Content tab" section.

  12. #12
    Join Date
    Oct 2009
    Posts
    11

    Default

    use 'Select values' step between "Text file input" and "Table input". That should solve the problem.

  13. #13
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    Well, this thread is really old, and I believe it was already solved...
    (en) Path to Pentaho knowledge: (1:Search the Wiki > 2:Search the Forums > 3:Ask) or (1:Get a Subscription)
    (es) El camino al conocimiento en Pentaho: (1:Buscar en la Wiki > 2:Buscar en los Foros > 3:Preguntar) o (1:Comprar una Subscripción)

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.