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

Read records up to a unique value in a column

MRoyW
8 - Asteroid

Hi, I have multiple worksheets that I want to combine using a batch macro. However, each has a different number of rows (line items) that I would like to be selected up to the total cost of goods. For example, shown in the table: (Actual data has numerous columns for monthly actuals, budget and forecasts)

How can I select records using such a criteria?
Thanks

ItemValue
Revenue 
tg4
ju13
Total revenue17
COGS 
tg3
ju11
Total COGS14
7 REPLIES 7
OllieClarke
15 - Aurora
15 - Aurora

Hey @MRoyW in your batch macro, have something like the below which finds the recordID of the 'Total COGS' row, appends that recordID onto all records, and then only keeps the records before that RecordID.

OllieClarke_0-1603364089268.png

 

Hope that helps,

 

Ollie

 

Qiu
20 - Arcturus
20 - Arcturus

@MRoyW 
Is this what you want?1022-MRoyW.PNG

Qiu
20 - Arcturus
20 - Arcturus

@OllieClarke 
Ours are surprisingly similar!😁
My formula tool seems to be reduntant.

MRoyW
8 - Asteroid

Thanks, that works perfectly.

MRoyW
8 - Asteroid

Yes, I had a look at both and they're similar. Thanks guys 😄

Qiu
20 - Arcturus
20 - Arcturus

@MRoyW 
Maybe you can also mark mine?😁

Qiu
20 - Arcturus
20 - Arcturus

@MRoyW 
Thank you very much. I am trying to get 50 accepted. hhaa

Labels