If you may, please send your inquiry to firstname.lastname@example.org and the Datawatch Global Support Team can open a ticket for you. We will provide possible solutions to your concern.
Technical Support Supervisor
With your DataPump, you can use &&filter&& as a wildcard in export names for tables and files. But also, there are useful calculated field functions that will let you get the first day of the next month easily - regardless of the filter value, perhaps using a runtime parameter or just based on Today().
Hi Olly and Joe,
Thanks for your suggestions. Apparently my issue is not clear enough. I don't want to dynamically filter on the time period. What I need is to run a project 12 times, each time changing the month.
Basically I've a full year budget figure for several measures for each division / segment / customer and I want to apply a phasing to this, in order to get the monthly figures. Rather than creating 12 columns for each measure (e.g. volume, sales, margin, and so on) and 12 summaries (one for each month), I wanted to make records which I need anyway in order to use them in pivot tables. Therefore I opened my full year (FY) budget file and linked it to a phasing table on multiple fields of which one is period. So in case the period field changes to another month, it will calculate the records for that month. If I would then run 1 summary 12 times with 12 different filters (changing the period) adding the records to one file, it would save me the work of having so many columns and different summaries.
The thing gets more complex as I need to split the budget for different managers (either by region or by segment).
I know it can be done in other ways, but none without having a lot of columns or having to run several processes one after the other. Or changing the period field 12 times manually.
ollyinmunich: the &&filter&& option in Automator / Datapump only works for tables and files, not for fields (?). I really need it as a field in the data for the pivot table.
Open for more suggestions
Is the source file a report or a database? I guess it's an Excel? If you get it from SAP can you get it as a text file?
Reason for asking is that using MultiColumnRegion could solve the problem in five minutes, but that's only available for text files.
I have suggested this as a feature request - to be able to use Column() on database sources - but Datawatch seem to think that the unpivot feature in Designer is enough.