topic Append Number to Day of Week in App Development

Append Number to Day of Week

Wed, 14 Sep 2016 18:40:38 GMT

Hello All,

My business is very cyclical within each month. I would like to monitor performance based on the day of the week. I was able to extract the day of the week using the weekday function. My next step is to append/prepend a figure 1,2,3,4,5 to represent the weekday of the month. First Monday = Monday1, Second Monday = Monday2, etc.

Any idea as how to accomplish this?

Thanks,

Re: Append Number to Day of Week

swuehl — Wed, 14 Sep 2016 18:46:51 GMT

Maybe like

LOAD *,

WeekDayName & Autonumber(Week(Date), MonthName(Date) ) as NewField;

LOAD

... // your calendar code including the WeekDayName and Date field

Re: Append Number to Day of Week

sunny_talwar — Wed, 14 Sep 2016 18:48:31 GMT

May be like this:

LOAD Date,

WeekDay(Date) as WeekDay,

WeekDay(Date) & AutoNumber(RowNo(), WeekDay(Date)&Month(Date)) as WeekDayNum

Resident ....;

Re: Append Number to Day of Week

swuehl — Wed, 14 Sep 2016 18:57:39 GMT

Another option not depending on the order of the dates in the input table would be

LOAD WeekDay(Date) & (Div(Day(Date),7)+1) as Test,

LOAD Date(MakeDate(2016)+recno()-1) as Date

AutoGenerate 366;