May 18, 2016 at 8:14 pm
Hello,
I am looking to create a script that I would enter parameters to auto create records instead of entering one record at a time.
For example, I have 10 sections with varying amount of rows, and I want to create 1 row for each day for the next 3 years.
Section 1, Num of spaces 10 for Years 2016, 2017, and 2018
Section 2, Num of spaces 10 for Years 2016, 2017, and 2018
Section 3, Num of spaces 15 for Years 2016, 2017, and 2018
Section 4, Num of spaces 15 for Years 2016, 2017, and 2018
Section 5, Num of spaces 15 for Years 2016, 2017, and 2018
Section 6, Num of spaces 20 for Years 2016, 2017, and 2018
Section 7, Num of spaces 20 for Years 2016, 2017, and 2018
Section 8, Num of spaces 10 for Years 2016, 2017, and 2018
Section 9, Num of spaces 22 for Years 2016, 2017, and 2018
Section 10, Num of spaces 22 for Years 2016, 2017, and 2018
Is the a way to setup a script to automate this kind of scenario?
May 18, 2016 at 8:32 pm
Use a Tally table and a deliberate cross join?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply