🎉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

How to store each iteration of the loop with different filenames ?

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

Sort by:
1 - 4 of 41
    User: "BalazsBaranyRM"
    New Altair Community Member
    Accepted Answer
    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
    User: "Harshav"
    New Altair Community Member
    OP
    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 . 
    User: "MartinLiebig"
    Altair Employee
    Accepted Answer
    Hi,
    I think you can use the normal Generate Macro within a Radoop Nest. Not sure though - please give it a try.

    Best,
    Martin
    User: "Harshav"
    New Altair Community Member
    OP
    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} :)