Customer Portal

Reading Horizontally mapped excel data in Clover

Comments 2

  • Avatar
    slechtaj
    0
    Comment actions Permalink
    Hi WilliamTell,

    the thing is that you are using XLSDataReader. If you would like to read data from XLS file horizontally, you should use new SpreadsheetDataReader instead, but it is not available in Community Edition.

    SpreadsheetDataReader offers the mapping tool you mentioned in your post. You can simply drag&drop metadata fields to spreadsheet. However, before you do so, you should change "Orientation" in global properties (right bottom pane in Spreadsheet Mapping Editor). Should you need any further information about SpreadsheetDataReader, please visit http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/spreadsheetreader.html.
  • Avatar
    williamtell
    0
    Comment actions Permalink
    Thanks for your reply slechtaj. I will give that a try.

Please sign in to leave a comment.