saving the row with the latest status

[becki]

i have data which is tracking the life of a vehicle, by VIN:  the order, the creation, the transport and the retail sale, in one file.  i want to report only on the last entry, for each VIN.  if i inverse the data (since its appended to each day) and summarize on the vin, how do i bring in the rest of the fields with it?  (In ACL, the language I used to work in, there was an "ALL" command that would just carry along the rest of the fields, from whatever row).  

thanks

becki kain

[MarqueeCrew · Accepted solution]

@becki,

If you SORT by VIN, [Date] instead of summarize, then use a SAMPLE tool where you select the 1st N (1) record, you should get just that newest record.

Cheers,

Mark

[becki]

it's a file of millions of different VINS and their statues, not just one, so that won't work.  other ideas?

[carlosloureiro]

Hello Becki,

I am also new to Alteryx and have been using ACL Analytics for 20 years and would like your opinion on the main advantages you are having with Alteryx in relation to ACL as well as the experience of users in the business areas.

I will be very grateful for your contribution.

[soccertil1108]

You can Group by column in the Sample widget. Alternately after the Sort you can Unique by VIN and get the first record for each VIN as ordered by Date desending.