Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have 1 service_date column, where the client wants to create a filter field to select weekdays and all days.
Like when i select weekdays than it should select the number of total days for weekdays in the service_date column.
when i select all days than it should select the number of total days for all days in the service_date column.
You can try like:
Load
service_date,
If( Not Match(Weekday(service_date), 'Sat', 'Sun'), 'WeekDay') as WeekdayFlag
From <>;
Concatenate
Load
service_date,
'AllDays' as WeekdayFlag
From <>;
You can try like:
Load
service_date,
If( Not Match(Weekday(service_date), 'Sat', 'Sun'), 'WeekDay') as WeekdayFlag
From <>;
Concatenate
Load
service_date,
'AllDays' as WeekdayFlag
From <>;
Can you please elaborate?