Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Postgres field transformation changed to lower case

  1. #1
    Join Date
    Jan 2017
    Posts
    3

    Exclamation Postgres field transformation changed to lower case

    I created a PostgreSQL below

    select b.idm_id as goal_IDMID, a.goal_year::text,a.goal_number as goal_no, a.goal_type, a.goal as goal_content, a.progress as goal_progress, a.created_at, a.updated_at from kmdata.ext_goal_and_progress a
    join kmdata.user_identifiers b
    on a.user_id = b.user_id
    order by b.idm_id, a.goal_year, a.goal_type, a.goal_number

    And the first field is goal_IDMID but when run preview it changed to goal_idmid, no clue why it changed to case to lower, any idea how to get around this issue? I need the final to goal_IDMID, not goal_idmid.

    Thanks
    Greg

  2. #2
    Join Date
    Aug 2011
    Posts
    236

    Default

    Hi Greg,

    By default, Postgres convert to lowercase. I found this in a post :-

    If you want upper- or mixed-case, you can quote the identifier e.g.:

    createdb "M_122_KL0001_2011_001_0100001"

    so try "goal_IDMID"

    HTH
    PDI 8.0.0
    MySQL - 5.6.27
    Redshift - 1.0.1485
    PostgreSQL 8.0.2
    OS - Ubuntu 10.04.2

  3. #3
    Join Date
    Jan 2017
    Posts
    3

    Default

    I tried "goal_IDMID" and 'goal_IDMID', none works. Immediately after you put quotes around it, it changed to color red.

  4. #4
    Join Date
    Jan 2017
    Posts
    3

    Default

    I added another step to use "Select values" to rename the field name and it worked.

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.