Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Normalizing data from a Sales force input step.

  1. #1
    Join Date
    Mar 2014
    Posts
    181

    Post Normalizing data from a Sales force input step.

    Hello everyone.

    I have a task to read items data from a Salesforce system.

    The data in the SKUs_r field appears as an array object, please correct me in case I am wrong.

    I need this data to be organized when retrieved from the Salesforce to be readables especially in the 'SKUs_r' field when I am inserting it into relationable database table.

    An example how I would read it would be like:
    product_id Name SKU_length_c SKu_item_map_price_amt_c, sku_item_height_c
    EL200096 200696 2.125 19.99 5.25

    Your help will be highly appreciated.
    Attachment 13137

    Thanks,

    Ron
    Last edited by Ron256; 04-15-2014 at 11:18 PM.

  2. #2
    Join Date
    Mar 2014
    Posts
    181

    Default

    Can someone please help me out here?

    Thanks,

    Ron

  3. #3
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    When attaching an image containing text, make sure it can be read.

    BTW: It's always best to pack your data in a Datagrid and attach a transformation!
    So long, and thanks for all the fish.

  4. #4
    Join Date
    Mar 2014
    Posts
    181

    Default

    I have attached some data in a text file with a transformation.

    Thanks,

    Ron

  5. #5
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    You can use a JSON Input step to parse field SKUs_r:

    Name:  SKUs_r.png
Views: 21
Size:  19.8 KB
    So long, and thanks for all the fish.

  6. #6
    Join Date
    Mar 2014
    Posts
    181

    Default

    Marabu,

    Thank you so much!

    thanks,

    Ron

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.