Use input data for single name output file name / custom Output Variable

Feature request
1

My use case:
I have a data source which among other things contain a field like:

Order Captured Date
2024-11-07
2024-11-06
2024-10-31

I now would like to be able to change the output filename to contain “2024-11” to indicate the last month in the dataset.
This could be achievable if I could create a branch and do the necessary filters and transforms (in this case to filter for the oldest date, reformat it) and the last transform would allow me to “select” (maybe similar to “Unique” to get a single row - or use Unique before and then that new transform works on single line datasets only and creates an error otherwsie) a datapoint/column to be set as a custom “Output variable” that I can use in any filename in the project so I could have for example “purchases to 2024-11” and “refunds to 2024-11” in two output branches.

2

I think this does what you want:

image
image1216×318 58.7 KB

month.transform (7.3 KB)

3

Weird with the warnings and what’s needed, but it does find the month. And the Cross adds it nicely.

I played around with it, and if the values like purchase/refund are in the fields like here, then we don’t need the two branches after the cross. Just one substitute and one output:’
image
I used the Substitute:

PayPal $(Status)-$(Month).csv

And that creates both files at the outout:
image

4

I left the days of the data and was a bit sloppy with the Slice options. Here is a better version:

month2.transform (7.4 KB)

True.

5

Oh cool. Now I understand it better. Thank you.

6

A thought: It may be useful if Substitute would come up when searching the transforms for combine or concat. And maybe even concat as well if searching for combine?

1 Like