I would like to create a list of days that a trip is run. As an example here is a single trip id, that runs 4 days in a short period, based on the date of operation, I would like to create a list of all the days that this trip ran, ie "Tues, Wed".
I am currently generating a list that seems to be all weekdays with the below script.
Load TRIP_ID, Concat(DISTINCT Day,',') as DayList Resident temp_st Group By TRIP_ID;
I think i need to include the OPERATING_DAY, somehow to get the correct list. Can the community tell me what I'm doing wrong and help create the desired list for each row.