How to get last transaction in 2 column

[bsbernabe]

Hello There,

My concern is how can get the last transaction BIN No. what i have right now is like this:

Load [Serial No.],

Max([Internal ID]) as MAX_Internal_ID

Resident Inventory

Group By [Serial No.];

But also i need to get is the last transaction in BIN No. any other way about this?

This is the sample Data:

ID	Serial No.	BIN No.
380549	ABCDE15665	G600KW03
597630	ABCDE15665	G600KW03
597630	ABCDE15665	G600TCRNG

This is what data that i need to display.

ID	Serial No.	BIN No.
597630	ABCDE15665	G600TCRNG

Best Regards,

Bing

[bramkn]

Use peek with -1 as the record.

Might be able to use a where statement on the recno and use -1 there. Not sure.

[sasiparupudi1 · Accepted solution]

May be try

Load [Serial No.],

MaxString([BIN No.]) as MAX_BIN_No

Resident Inventory

Group By [Serial No.];

[tresesco]

I guess you need: LastValue()‌

[bramkn]

Didn't see this function yet. Nice one thanks.

[bsbernabe]

Hello Bram,

You didn't  not see cause  that script is incomplete i add that script in my script and it is work.

Note:

Thank you so much also for your support.

Best Regards,

Bing