Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Is there any way to use "filename from field" in Excel Writer or Excel Output?

  1. #1
    Join Date
    Jun 2016
    Posts
    181

    Default Is there any way to use "filename from field" in Excel Writer or Excel Output?

    Hi,

    Is there any way to use "filename from field" in Excel Writer or Excel Output?

    If you could please give some advice how to build some workaround.

    G.

  2. #2
    Join Date
    Jun 2016
    Posts
    181

    Default

    I've managed that. Example transformation:

    Transformation 1:

    Text-file-input => Sort rows (sort by filename) =>Transformation Executor (filename as parameter, row grouping by filename)

    Text file content:
    filename;data
    file1;xx
    file1;nndd
    file2;gsdfs

    Transformation 2:

    Get rows from result => Microsoft Excel Output (filename ${Internal.Entry.Current.Directory}/${filename})

    Maybe someone will need it

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.