10-21-2016 05:21 PM
This is Saurabh here, Im trying to automate my daily task of loading data suing sql query(complex query which has multiple temp tables and joins) from sql server db, into Rapid miner to export the results into user defined excel format,
I have tried using Read databsse operartor, but since my query is lengthy and has multiple components within it, it does not run, I also tried a combination of execute sql and read data base but no luck.
I would really appreciate if someone can help me with my issue
10-24-2016 01:38 PM
For making the queries dynamic, you should use "Macros". Here is a primer on this: http://community.rapidminer.com/t5/RapidMiner-Studio-Knowledge-Base/How-to-Use-Macros/ta-p/32966