"Split 2 columns (one fixed, one variable) into seperate datasets"

felix_w

Dear Rapidminer Community,

I have a problem I hope you can help me with. I am trying to split an excel file with ~500 columns into seperate data files. The design I need to have is that I would like to fix the first column (Column A is the date) and combine it with the next column (B) (attribute) and save this dataset. Then again (Column A + Column C), (Column A + Column D) etc. until the last column. All of these combinations should be saved seperately.

I tried to handle this with "loop attribute" and "select attributes" in the loop but the problem is that my construct is stuck at the first attribute and doesnt go further then Column A + B. I wasn't able to make the loop work to go A + C, A + D, etc. The "select attribute" operator seems not to be dynamic, I cant use any macro with it? Is there another operator which I could use?

Does anybody know how I can solve this problem? Is there any other way than my loop?

This is what I have done so far:

<参数键= " enable_parallel_execution" value="true"/>

MartinLiebig

Hi,

the loop is the way to go. And I think you are nearly done. You just need to use the %{loop_attribute} in Select attributes as well. I think my attached process should do it.

Cheers,

Martin

Not sure what this should do..

felix_w

This is exactly what I needed! Thank you so much!