🥳 RAPIDMINER 9.9 IS OUT!!! 🥳
The updates in 9.9 power advanced use cases and offer productivity enhancements for users who prefer to code.
CLICK HERE TO DOWNLOAD
Loop until the value of two macros are equal?
Hello, I am looking to pull a large amount of data from a server which limits how many points i can pull each time i access it. I would like to get around this by looping the pull and building the table iteratively.
Below is some pseudo code of what i'd like to do:
INSIDE LOOP
%{Moving End} = IF %{Start Time} + %{Step Size} < %{Final End}
THEN %{Start Time} + %{Step Size}
ELSE %{Final End}
Execute Data Pull Block
Append New Pull to Table
%{Start Time} = %{Moving End}
BREAK IF %{Start Time}=%{Final End}
Any help on how to tell the loop to break on this condition would be appreciated, thanks!.
Below is some pseudo code of what i'd like to do:
INSIDE LOOP
%{Moving End} = IF %{Start Time} + %{Step Size} < %{Final End}
THEN %{Start Time} + %{Step Size}
ELSE %{Final End}
Execute Data Pull Block
Append New Pull to Table
%{Start Time} = %{Moving End}
BREAK IF %{Start Time}=%{Final End}
Any help on how to tell the loop to break on this condition would be appreciated, thanks!.
Tagged:
0
Best Answer
-
mschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 2,898
 RM Data Scientist
Hi @ZKuiper ,to your original Question. You could use Throw exception to break the loop and then catch the exception outside with Handle Exception.Best,Martin- Head of Data Science Services at RapidMiner -
Dortmund, Germany5
Answers
Are you trying to pull data in batches from OSI server (cc. @Michael )? You can list the timestamps for start time and end time in a reference table and apply "loop values" with macro.
Let me know if you have followup questions..
Cheers,
YY
As a side note I have figured out how to automatically add in a tag list from excel using the "Set Macros from Example Set" and it works well so that ask can fall down the list a bit.