Hello,
I'm working on a project where we need to generate rows (dates) using the in-db tools.
This was done in the past without the in-db tools and we used "Generate Rows" as we needed an initialization expression, a condition and a loop.
Is there a way to replicate "Generate rows" with any in-db tool?
Thanks!
Solved! Go to Solution.
Hey @EzequielO
There is no Generate Rows in-Db but you could generate the rows then use the datastream-in tool to bring these values back into your In-DB workflow?
Hey LordNeilLord, yes I will be using that solution untill we think of something else. Thanks!
I'm working in a redshift db of a supplier with 13 mio rows and I need to generate more rows.
Working indb will save me a ton of time, is there any possibility to generate rows in db so I can use the processing power from Redshift before I download the data?