Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Update table and variable replacement

  1. #1
    Join Date
    May 2006
    Posts
    167

    Default Update table and variable replacement

    Hi,
    I have troubles trying to update some records fetching some variable in lookup conditions (see attached image).
    I read in the forum a message in year 2006 where it was stated that variable replacement is (still) not done.
    In PDI 3.2.0 it's still undone, as I experienced.

    Do you confirm, please?

    Thank you,
    Nicola
    Attached Images Attached Images  

  2. #2
    Join Date
    May 2006
    Posts
    167

    Default

    I forgot to list the error:
    ${IMPIANTO} required but not found.

    2009/07/21 14:51:54 - org.pentaho.di.trans.steps.update.Update - ERROR (version 3.2.0-M2, build 1 from 2009-02-05 09.34.34 by nicola) : Errore inatteso :
    2009/07/21 14:51:54 - org.pentaho.di.trans.steps.update.Update - ERROR (version 3.2.0-M2, build 1 from 2009-02-05 09.34.34 by nicola) : org.pentaho.di.core.exception.KettleStepException:
    2009/07/21 14:51:54 - org.pentaho.di.trans.steps.update.Update - ERROR (version 3.2.0-M2, build 1 from 2009-02-05 09.34.34 by nicola) : Il campo [${IMPIANTO}] è richiesto ma non è stato trovato!
    2009/07/21 14:51:54 - org.pentaho.di.trans.steps.update.Update - ERROR (version 3.2.0-M2, build 1 from 2009-02-05 09.34.34 by nicola) :
    2009/07/21 14:51:54 - org.pentaho.di.trans.steps.update.Update - ERROR (version 3.2.0-M2, build 1 from 2009-02-05 09.34.34 by nicola) : at org.pentaho.di.trans.steps.update.Update.processRow(Update.java:234)
    2009/07/21 14:51:54 - org.pentaho.di.trans.steps.update.Update - ERROR (version 3.2.0-M2, build 1 from 2009-02-05 09.34.34 by nicola) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2678)
    2009/07/21 14:51:54 - org.pentaho.di.trans.steps.update.Update - ERROR (version 3.2.0-M2, build 1 from 2009-02-05 09.34.34 by nicola) : at org.pentaho.di.trans.steps.update.Update.run(Update.java:511)

    Bye
    Nic

  3. #3
    Join Date
    Feb 2009
    Posts
    296

    Default

    You can't use variables everywhere. Correct.
    Especially field names are seldom (if ever) replaceable by a variable name.

    Each textfield that accepts variables has a little symbol in it (to the very right). Also these fields support pressing CTRL+Space to list all known variables.

    These two indicators should help you.
    Fabian,
    doing ETL with his hands bound on his back

  4. #4
    Join Date
    Feb 2009
    Posts
    321

    Default

    try using the step get variables and put the name of variable in the field ( step update)( in this case IMPIANTO, take away '$' and '{}').
    Like this IMPIANTO
    not this: ${IMPIANTO}

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.