Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Case problem...

  1. #1

    Red face Case problem...

    Hi,

    I have to insert distinct rows in to the target tabel by comparing the Product_author in sorce table and author_name in the target table.But thing is we have differnt cases in both the column some in the upper case and some in the lower case.some how i mange to chage the case in to the lower to the Product_author by using java script but i am unable to convert the target table author_name in to the lower case.so i am getting wrong data into the target table.

    so if any one have any idea please help me to move farward.....

    Thanks&regards,
    jagadishvarma.

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

    Default

    And the javascript case change did not work for the second column?

    You could also try and add some kind of lower case function to your SQL code in your input step...

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.