Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: insert select max values in al list

  1. #1

    Default insert select max values in al list

    Hi All,
    I've a problem that i cannot solve..
    I have a list and i must add for every rows a new fields with select max+1 value of a table, what can i do?
    If I try to get value of select max with "execute query script" (for each row) transformation show error for ORA-01000 maximum open cursors exceeded.

    help me please

  2. #2
    Join Date
    Apr 2014
    Posts
    14

    Default

    Hi absolutezer0

    You don't need to use "execute sql script" or write any complex script. You can do this by using a very simple mapping like the one attached here. Just put your input mapping on the place of "Data Grid" component, and your task will be completed.
    I hope this will help you.
    Let me know if you still have any problem in it.

    Max_Value_Example.ktr

    With Regards
    Rahul Trivedi

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.