Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Excel to Excel Mapping

  1. #1

    Default Excel to Excel Mapping

    Dear Experts....

    I have a requirement for excel to excel mapping...2 Excels, Different column names in source and target. Need a column mapper.

    Eg: I have a input as excel workbook which contains 5 fields. Fields in th source excel are say.... Cust_Id, Cust_Name, Seg, Pan

    I want to export the data into another excel with 20 fields.
    The Fields in the Target excel are:

    S. No. Customer Id, Name, Segmentation, PAN Id

    I wasn't able to find any mapper to map these columns.
    Request you to please help me out if there is any way I can do that.
    Thanks a lot in advance
    Thank you

    Cheers
    Ronak Shah

  2. #2
    Join Date
    Apr 2008
    Posts
    4,686

    Default

    Use Select Values step "Select and Alter" (Tab) to change field names.

Tags for this Thread

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.