Create data based on daily time stamps

[PH573]

Hello,

This should hopefully be the last topic involving my months long wrangling of app availability data.

I have now hardcoded dates into my data in order to allow for better use of time intelligence functions. Is there a way I can populate data for weeks in the future from these hardcoded dates that would not require me to manually copy and paste the entire data set for a given week?

For an example, let's say I have the following information on two apps below.

App Name	App Code	Date/Start Time	Date/End Time	Day Of Week
Generic App A	1111	12/4/2022 12:00:00AM	12/4/2022 11:59:59PM	Sunday
Generic App A	1111	12/5/2022 12:00:00AM	12/5/2022 11:59:59PM	Monday
Generic App A	1111	12/6/2022 12:00:00AM	12/6/2022 11:59:59PM	Tuesday
Generic App A	1111	12/7/2022 12:00:00AM	12/7/2022 11:59:59PM	Wednesday
Generic App A	1111	12/8/2022 12:00:00AM	12/8/2022 11:59:59PM	Thursday
Generic App A	1111	12/9/2022 12:00:00AM	12/9/2022 11:59:59PM	Friday
Generic App A	1111	12/10/2022 12:00:00AM	12/10/2022 11:59:59PM	Saturday
Generic App B	2222			Sunday
Generic App B	2222	12/5/2022 12:00:00AM	12/5/2022 10:00:00PM	Monday
Generic App B	2222	12/6/2022 12:00:00AM	12/6/2022 10:00:00PM	Tuesday
Generic App B	2222	12/7/2022 12:00:00AM	12/7/2022 10:00:00PM	Wednesday
Generic App B	2222	12/8/2022 12:00:00AM	12/8/2022 10:00:00PM	Thursday
Generic App B	2222	12/9/2022 12:00:00AM	12/9/2022 10:00:00PM	Friday
Generic App B	2222			Saturday

What steps would I need to take to get this data to repeat for rest of the month of December, while also keeping the blank spaces for offline apps intact? Thank you in advance.

[Ashish_Mathur]

Hi,

Your question is not clear.  What are the input columns and what result are you expecting?  What is the use of the End Date column?  Why are there no entries in 2 rows?

[PH573]

My apologies for the lack of clarity.

The two blank rows are meant to represent an application that is offline for that given day. I am hoping to get a table like the input, but with the dates in Date/Start Time and Date/End Time repeating up to a given end date. The Date/Time columns are meant to show the start time and end time of an app's availability in the day shown in the timestamp.

[Ashish_Mathur]

Hi,

Show the expected result very clearly.