Generate new rows

[jswirat]

Hi,

I have a table that looks like this:

Box	Element
Box1	AMOUNT
Box1	PRODUCT
Box1	BRANCH
Box2	BASEAMOUNT
Box3	BRANCH

What I'm trying to do is for each box value that does not have BASEAMOUNT as an element, I need to generate a row so it looks like this:

Box	Element
Box1	AMOUNT
Box1	PRODUCT
Box1	BRANCH
Box1	BASEAMOUNT
Box2	BASEAMOUNT
Box3	BRANCH
Box3	BASEAMOUNT

I've been trying to use the GenerateRows tool, but I'm so lost.

[Emil_Kos]

Hi @jswirat,

I am not following that.

Can you explain it a little bit more?

[messi007]

@jswirat,

Please see below:

Attached the workflow,

If this solves your issue please mark the answer as correct, it will help others!

Regards,

[JoeS · Accepted solution]

Hi @jswirat 

I went about it slightly differently.

I captured each Box value, then added the Element field and unioned them all back in. 

Finally the Unique removes any duplicates that already had the BASEAMOUNT.

[Emil_Kos]

Hi @jswirat,

Actually I figured it out. I created a base amount positions for each box in the data and used unique tool afterwards.

As I was thinking that you will need to have a base amount as a last row I have used sort tool with additional column created only for sorting purpose.

Please mark as a solution if this was helpful!