cancel
Showing results for 
Search instead for 
Did you mean: 

Looking for an expression to tie many to one

acesario
Contributor II

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.

1 ACCEPTED SOLUTION

bojanvelevski
Valued Contributor

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.

Structure_Transformations_V2_2021_02_16.slp (4.0 KB)

View solution in original post

5 REPLIES 5

pvanteru
New Contributor

Thank you, this is working perfectly 🙂