Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
How to store each iteration of the loop with different filenames ?
Harshav
Fore each iteration ,I get one dataframe which needs to be stored with the table name as table_name_{value}.Can you suggest me how to store all loop results with different table names
Find more posts tagged with
AI Studio
Accepted answers
BalazsBaranyRM
Hi,
in the Write Database operator (and almost everywhere else) you can use macros in the "table name" parameter.
It would be something like: table_name_%{loop_nr}
The iteration number would be in a macro, this is mostly automatic with the Loop operators in RapidMiner.
There are different videos for macros in the Academy if you'd like to learn more about them:
https://academy.rapidminer.com/catalog?query=macros
Regards,
Balázs
MartinLiebig
Hi,
I think you can use the normal Generate Macro within a Radoop Nest. Not sure though - please give it a try.
Best,
Martin
All comments
BalazsBaranyRM
Hi,
in the Write Database operator (and almost everywhere else) you can use macros in the "table name" parameter.
It would be something like: table_name_%{loop_nr}
The iteration number would be in a macro, this is mostly automatic with the Loop operators in RapidMiner.
There are different videos for macros in the Academy if you'd like to learn more about them:
https://academy.rapidminer.com/catalog?query=macros
Regards,
Balázs
Harshav
Hi balazs,
Thank you for responding to the above problem. FYI I'm working in radoop nest and I could find only two operators loop and loop attributes .
When I'm storing in hive database like you said table_name_%{loop_attribute} , I couldnt store in different tables since %{loop_attribute} is just column name. How do i store it with different names in this case ?
P.S.- There is loop values that can be used in sparkrm but my whole process is built with radoop operators which needs to looped and store it with different names .
MartinLiebig
Hi,
I think you can use the normal Generate Macro within a Radoop Nest. Not sure though - please give it a try.
Best,
Martin
Harshav
Thank you martin I used extract macro(sparkrm) in loop attributes and store it with different names in store in this format table_name_%{macro}
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups