Hello everyone,
I'm having a difficult time solving a very specific issue using Alteryx Designer.
I hope that someone within this community will be able to help out!
The situation is (luckily) rather easy to explain
I currently have a data input from Excel that looks like this:
| F1 | Monday | Tuesday | Wednesday | Thursday | Friday |
| Start time | 08:30 | 08:00 | 08:00 | 08:15 | 08:00 |
| End time | 16:00 | 15:30 | 15:30 | 15:45 | 15:30 |
| Hours | 07:30 | 07:30 | 07:30 | 07:30 | 07:30 |
| Ordinary time | 360 | 355 | 370 | 365 | 340 |
| Personal time | 55 | 60 | 45 | 50 | 75 |
| Task shifts | 15 | 10 | 12 | 11 | 10 |
I need make a workflow that will make data look like this:
| Day | Start time | End time | Hours | Ordinary time | Personal time | Task shifts |
| Monday | 08:30 | 16:30 | 07:30 | 360 | 55 | 15 |
| Tuesday | 08:00 | 15:30 | 07:30 | 355 | 60 | 10 |
| Wednesday | 08:00 | 15:30 | 07:30 | 370 | 45 | 12 |
| Thursday | 08:15 | 15:45 | 07:30 | 365 | 50 | 11 |
| Friday | 08:00 | 15:30 | 07:30 | 340 | 75 | 10 |
Any suggestion on how to perform this transformation within alteryx would be greatly appreciated.
Best regards,
Victor
