RecordID reset formula

[gabrielmier222]

I need a fromula (thinking multi-formula) that resets the RecordID back down to 1, when the date in a cell is different than the one above it. 

Example below is the excel desired output

[john_walker]

Based on your screenshot, you have NULLs in your date field, so my multi row formula is checking if the date above is NULL and the current date is not null - that's what does the reset of the record. Hope this helps.

[gabrielmier222]

Sorry for the confusion John, the previous screenshot is from an excel file I'm using for reference.

The screenshot below is the data that's being run in Alteryx. I'm trying to have the line after 23, reset to 1 and continue. I hope that's a bit more clear. Thanks in advance

 

[john_walker · Accepted solution]

OK, I provided an updated version. Please mark as solved if this helps - thanks!

[gabrielmier222]

Worked, but the RecordID does not continue in Sequence. Is this fixable? 

 

[john_walker]

Can you attached a sample of this file? Hard to tell as I can't see the date field etc. If not, I would just make sure your expression in the multi-row formula tool looks similar to this: if [DateFld] != [Row-1:DateFld] then 1 else [Row-1:Record] + 1 endif

Sample workflow:

Data before multi row formula:

Data after multi row formula

[natashaklebba]

Of course, John here's the workflow!

[gabrielmier222]

Good morning, John,

I'm following up on the above :)

[john_walker]

Hi - can you export as a package - I don't have access to the General Ledger Journal Entries xls file in the workflow.

[gabrielmier222]

Wasn't sure how to do that John. I replaced the file with a text input tool and copied the headers over.