Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I have a dataset which I would like to update several times to give me monthly records, for 12 months, for example. can this be done in an SQL recipe using loops? Or can it be done? pls let me know how. Thanks
Welcome to the Dataiku Community.
Although from your description it is hard to tell exactly what your use case is. Here are some thoughts that may help.
Although there is no loop construct across visual and code recipes in DSS. I will suggest 3 features of Dataiku DSS that may be helpful to achieving what you are trying to do.
Those three features of DSS give you some basic "looping" features.
That said if you actually need to loop something you can always write some Python or even R code. SQL can be called from each of these languages.
Hope those clues may help you a little bit.
--Tom
thanks for the suggestions