"Write Excel - generate excel file name / sheet name from parameter?"

Flouyd

Hey there!

Is it possible to incorporate the "sample ratio" from "Sample" into the Excel file path/sheet name?
Is there a function or at least a workaround to do that?

My process looks like this:
I read my ExampleSet from the repository and go into "Loop parameter".
In this loop, the ExampleSet goes into "Sample"; the looped parameter is the sample ratio.

From this sampled ExampleSet, a model (Linear Regression) is built and evaluated.
The performance is transformed to data with "Performance to Data" and written with "Write Excel".

Best regards,
Flouyd

Flouyd

Solution found!

Based on this reply from awchisholm (http://rapid-i.com/rapidforum/index.php?action=profile;u=118), thank you by the way!

Hello You could modify this example http://rapidminernotes.blogspot.co.uk/2012/07/chopping-files-into-smaller-bits.html regards Andrew

I created a "set macro" with the macroname "sampleratio" and value "0.05" right after the data retrieval!
Afterwards I went into my loop and implemented a "generate macro" with the name "sampleratio" and function expression "%{sampleratio}+0.05" that adds to this macro!
In naming the files, espacially "Write Excel" you can access this macro by %{sampleratio}.
My sheetname looks like this "Sheet_%{sampleratio}_raw" and returns Sheet_0.05_raw > Sheet_0.1_raw and so on!