Insert Rows For Each Category

[dataminer]

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!

[Jonathan-Sherman]

Hi @dataminer,

You could scaffold the data using a summarise and append fields:

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

[dataminer]

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.

RecordID	Category	Amount		RecordID	Category	Amount
1	A	2		1	A	2
1	C	8		1	B	0
1	D	6		1	C	8
2	E	4		1	D	6
2	F	3		1	E	0
				1	F	0
				1	G	0
				1	H	0
				2	A	0
				2	B	0
				2	C	0
				2	D	0
				2	E	4
				2	F	3
				2	G	0
				2	H	0

[Aaron_Harter · Accepted solution]

@dataminer the attached solution will allow you to keep your existing data points, and generate the 0's for all other amounts:

[Jonathan-Sherman · Accepted solution]

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