Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to? Excel field, 20+ Excel files

  1. #1
    Join Date
    Dec 2016
    Posts
    27

    Default How to? Excel field, 20+ Excel files

    Hi,

    I have a collection of Excel files and in all the first few columns are common. However, the many other columns which extend to the right represent business units and despite having the same header name, the column number can vary for the one business unit I am interested in if a new (other) BU was added in a given month. What's the slickest way to pick out the right field from 20+ files? Also, in some cases the business unit doesn't feature in a file. I can discern this manually but is there a way to build this check into some import logic?

    Any advice appreciated


    Regards,

    Andy

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

    Default

    Last edited by gutlez; 01-25-2017 at 08:10 PM.

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.