Loop through database tables

ammarghammargh MemberPosts:27Maven
edited November 2018 inHelp

RM has a "loop data sets" component.

My data sets are saved in a database. Is there is a way to loop through all database tables?

Tagged:

Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University ProfessorPosts:3,302RM Data Scientist

    hi,

    not with one operator. You can write a SQL statement generating you table of table names and use a Loop Values on it to get each table name as a macro. You can then use this table in the loop.

    ~Martin

    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
    Thomas_Ott SGolbert
  • JEdwardJEdward RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:578Unicorn

    Yes, you can use the Loop Repository operator and instead of pointing at your local repository point at the //DB/ where your stored connections are.

    Below is a quick example.





    <宏/ >




    < = " re参数的关键pository_folder" value="//DB/DemoDataStore/Example Sets/"/>
















    MartinLiebig Thomas_Ott
Sign InorRegisterto comment.