I have a (hopefully simple) Q -
I want to create duplicate records based on the count in column #2 -
ID Count1234 43456 17890 3
Should look like -
ID Count1234 41234 41234 41234 43456 17890 37890 37890 3
Am able to replicate in excel but have a large dataset. I've tried using row_number() but am unable to resolve. Any help is much appreciated.
Using a commodity table (CALENDAR) for a join or using a recursive query can be solutions for you.