"Write Excel - generate excel file name / sheet name from parameter?"
Contributor I
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.
性能是transformed to data with "Performance to Data" and written with "Write Excel".
Best regards,
Flouyd
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.
性能是transformed to data with "Performance to Data" and written with "Write Excel".
Best regards,
Flouyd
Tagged:
0
Answers
Based on this reply from awchisholm (http://rapid-i.com/rapidforum/index.php?action=profile;u=118), thank you by the way!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!