Generate new rows
- RSS-Feed abonnieren
- Thema als neu kennzeichnen
- Thema als gelesen kennzeichnen
- Diesen Thema für aktuellen Benutzer floaten
- Lesezeichen
- Abonnieren
- Stummschalten
- Drucker-Anzeigeseite
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Moderator informieren
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.
Gelöst! Gehe zu Lösung.
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Moderator informieren
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Moderator informieren
Please see below:
Attached the workflow,
If this solves your issue please mark the answer as correct, it will help others!
Regards,
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Moderator informieren
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.
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Moderator informieren
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!