I have 8 total categories. A-H. Each record only contains some of the categories.
How would I go about adding just the categories that are missing?
Excel Screenshot for reference.
Thanks!
@dataminer the attached solution will allow you to keep your existing data points, and generate the 0's for all other amounts:
Hi @dataminer,
In that case I would just add a little bit extra:
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Regards,
Jonathan
You could scaffold the data using a summarise and append fields:
I need to keep the rows from the original data set since there is other info in other columns that I left our for simplicity.
I updated my data structure below.
