Hi guys,
I need a solution to export a list of summarised data to CSV.
As it stands the data looks like this:
Name | Shift | Quantity |
---|---|---|
Ashley Allen | Night Shift | 1 |
Ashley Allen | Day Shift | 1 |
Ashley Allen | Day Shift | 1 |
Ashley Allen | Night Shift | 1 |
Ashley Allen | Night Shift | 1 |
David Jones | Day Shift | 1 |
Kimberly Roberts | Day Shift | 1 |
I need to summarise the data into this (each [Quantity] is summed and compressed onto one line for each listed [Name] for each type of [Shift]):
Name | Shift | Quantity |
---|---|---|
Ashley Allen | Night Shift | 3 |
Ashley Allen | Day Shift | 2 |
David Jones | Day Shift | 1 |
Kimberly Roberts | Day Shift | 1 |
The job:
- Take the first example list, and summarise it into the second list, then export it to CSV.
- I need to take the workflows and translate them into my application.
- I do not need the solution to be pretty or have a polished UI, just efficient and completely reliable.
The rub:
- The list is taken from a dynamic repeating group (not a static source).
- The real lists will be hundreds of lines long.
- This will likely need to be a backend solution.
- I cannot allow you access to my application due to PII, so it will need to be in its own environment.
What I know:
I have attempted to solve this myself. You cannot pass groupings to a backend workflow, nor can you extract data from them in a useful way, so groupings are out. I can export the raw data to CSV without issue.
Budget:
This is a one-off job, and hopefully a relatively short task for someone who knows the solution. I am open to discuss cost, though if development time is more than a couple of hours it makes little sense to proceed when the raw export is probably ‘good enough’.