Cross Distance in a Loop for every row vs. single loading of each excel file
Hyperrick
New Altair Community Member
Hello, everyone,
I am currently in the process of optimizing processes.
We want to calculate the cross distance and are currently cutting a file with 180 lines into 180 individual Excel files. The cutting is done by looping the file. Now we want to re-import this 180 Excel files via a loop and compare them one after the other with the reference set.
We have 180 requests and 1 reference set. Since we do not like to load the file 180 times manually into Rapidminer, we thought of a loop. Do you have any ideas?
See the process attached (sorry it's to long to post):
Patrick
0
Best Answer
-
Hi @Hyperrick,
Why don't you use directly your initial XLS file with 180 lines with the filter example range operator inside a Loop operator ?
Check the process in attached file to understand what I mean...
In attached files, 2 fictive XLS files :
- a request file (with 4 examples)
- a reference file (with one example)
Does this help ?
Regards,
Lionel1
Answers
-
Hi @Hyperrick,
Why don't you use directly your initial XLS file with 180 lines with the filter example range operator inside a Loop operator ?
Check the process in attached file to understand what I mean...
In attached files, 2 fictive XLS files :
- a request file (with 4 examples)
- a reference file (with one example)
Does this help ?
Regards,
Lionel1 -
Hello Lionel,
that fixed it! Perfect - thank you!
Patrick1