Pages: [1]
  Print  
Author Topic: Write Excel - generate "excel file name"/"sheet name" from parameter?  (Read 1136 times)
Flouyd
Newbie
*
Posts: 2


« on: August 15, 2013, 12:45:20 PM »

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
Logged
Flouyd
Newbie
*
Posts: 2


« Reply #1 on: August 16, 2013, 08:08:02 AM »

Solution found!

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

Quote

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!
Logged
Pages: [1]
  Print  
 
Jump to: