Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Repeat items and delete subtotals

MiroPwC
7 - Meteor

Hey guys,

 

I would like to ask you for your help with part of my flow.. I am sending you excel where you have 2 sheets.. First one consists of raw data. The point is to repeat Account number for all blanks above the row with account number and then delete this subtotal row. You can see desired output in the second sheet, where the selected account number will be in each relevant row  + the subtotal row is deleted.

 

May I ask you for help with this as I have never experienced something like this.

 

Thanks a lot.

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @MiroPwC I mocked up a workflow that produces your desired output let me know what you think?

MiroPwC
7 - Meteor

Works like magic 🙂 Thanks a lot

Labels