Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Multiple excel outputs with a variable file name

  1. #1
    Join Date
    May 2015
    Posts
    19

    Default Multiple excel outputs with a variable file name

    Hello every one,

    I'm trying to create multiple excel files in outputs using values in field Country as part of the filepath
    what I have now is this

    Name:  switch_case.png
Views: 64
Size:  15.4 KB

    Switch / Case is to make multiple files according to countries
    each country file is in a different output
    The thing is that I have more countries and I don't think that the best way is to create outputs as much as the number of countries

    Any help will be appreciated

  2. #2
    Join Date
    Nov 2013
    Posts
    9

    Default

    you need to parameterize on excel file name appending with dynamically changing column.so that, it will create n of file based on your output of the defined column.

  3. #3
    Join Date
    Jun 2015
    Posts
    12

    Default

    logu002: Could you plz let me knw how the parameterization is done. i'm stuck with a similar issue. Thanks in advance.

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.