โ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-13-2021 09:48 AM
Hi @acesario
I upploaded a pipeline with JSON Generator and Mapper with expressions for the desired transformation. Please check if the data stream is correct.
Structure_Transformations_2021_02_13.slp (3.9 KB)
BR,
Bojan Velevski
โ02-15-2021 03:32 AM
Excellent, and thanks for the great example of using split and join!
โ02-16-2021 07:02 AM
Hi @bojanvelevski,
Thank you for solving this.
We got a small issue with the solution, as the Meeting days are not always two days, we need to associate start times and end times based on the number of days instead of only two times. For example the scenario will be as below
โMEETING_DAYSโ: โM,W; TU,TH; M,W,Fโ, >> โMEETING_DAYSโ: โM;W;TU;TH;M;W;F",
โMEETING_START_TIMESโ: โ08:00;14:45;13:00โ, >> "08:00;08:00;14:45;14:45;13:00;13:00;13:00โ,
โMEETING_END_TIMESโ: โ09:15;16:00;14:00โ, >> โ09:15;09:15;16:00;16:00;14:00;14:00:14:00โ
โ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.