The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
"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.
The performance is 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.
The performance is 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!