get the last number or record id

[PassION_es]

Hello Alteryx Community,

May I request your assistance on what the right tool to use to get the last number (record id) of each bank account.

Attached is the sample input and output.

[flying008 · Accepted solution]

Hi, @PassION_es 

You can use Summarize tool to get your want:

1- Group by [BANK ACCOUNT]

2- Last by [SEQUENCE]

[aatalai · Accepted solution]

could also be done by Max by Sequence, but either way would get you the same answer

[PassION_es]

wow, amazing! Thank you @flying008 & @aatalai