🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Cross Distance in a Loop for every row vs. single loading of each excel file

User: "Hyperrick"
New Altair Community Member
Updated by Jocelyn
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


Sort by:
1 - 2 of 21
    User: "lionelderkrikor"
    New Altair Community Member
    Accepted 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,

    Lionel
    User: "Hyperrick"
    New Altair Community Member
    OP
    Hello Lionel,

    that fixed it! Perfect - thank you!

    Patrick