Need Help - Outputting filename with part of column value

User: "Altair Forum User"
Altair Employee
Updated by Altair Forum User

Hi Everyone,

 

I am a new Datawatch user and have been using Data Prep Studio version 14.2.

 

I have created a Workspace File which cleans up a file and outputs a summary table grouped by the column 'Group Name'.

    The Group Name column contains values such as: A1, A2, B1, B2, etc...

 

Current problem: I need to output the same report for each of the groups (currently have over 20 groups) on separate files (1 file per group). I have not been able to figure out how to create the outputs such that the filenames are as follows ('Groupname' Summary.xlsx).


GOAL: Looking for a way to append the GroupName column as part of the filename.

For example:
    A1 summary.xlsx

    A2 summary.xlsx

    etc...

 

Is there any way to achieve this result using a Workspace? (I also have Datawatch Server 14 available, if there is a way to do it there).

If I am not able to achieve the result with a Workspace can it be done with a Model?

 

Appreciate any help!

R

Find more posts tagged with