02-12-2021 01:26 PM
I would like to transform data as shown below. The idea is that M and W are associated with 8:00 start and 9:15 end (M,W=8:00-9:15). Tuesday and Thursday are associated with 14:45. M and W are currently separated by a comma, So are T and TH. M,W are separated from TU and TH by a ;
Current Structure > Desired Structure
“MEETING_DAYS”: “M,W;TU,TH”, >> “MEETING_DAYS”: “M**;W;TU;TH",
“MEETING_START_TIMES”: “08:00;14:45”, >> "08:00;08:00**;**14:45;**14:45”,
“MEETING_END_TIMES”: “09:15;16:00”, >> 09:15;09:15;16:00;16:00
So, comma values are grouped semi colon separated values are not.
I’m not sure I’m explaining this well, but hoping there is an approach that can help with this.
Solved! Go to Solution.
02-16-2021 08:45 AM
Hi @pvanteru,
Here’s an update that will take as many days, and as many ‘;’ separated batches you want. There is a sample in the pipeline that generates that kind of scenario. Please notify me if any updates are needed.
02-16-2021 09:39 AM
Thank you, this is working perfectly 🙂