Need to assign value for last Number of column

[Pinky]

Hi Team,

I need to assign TRUE or FALSE based on column. See my below data.

TicketNumber	TicketCount	LastValue
AA	1
AA	1
AA	1	TRUE
BB	2
BB	2
BB	2	TRUE
CC	3
CC	3	TRUE

So, I need to assign a "TRUE" statement for each ticket for the last value as shown above.

Please anyone help on this.Please let me know if you don't understand my query.

Regards,

Pinky 

[Kenda · Accepted solution]

Hey @Pinky!

If you add a Multi-Row Formula tool and create a new string field with the following expression, does this accomplish what you're looking for?

iif([Row+1:TicketNumber]!=[TicketNumber],"TRUE","FALSE")

[Pinky]

Yes,formula working as expected.Thanks!

I really appreciate your help!

Regards,

Pinky

[Pinky]

What if in case i need to update "TRUE" status for one row before last row of each Ticket Number?

Thanks,

Pinky

[Kenda]

@Pinky You will have to increase Num Rows to 2. Then, depending on if you still want your last row to be TRUE, try the following expression:

iif([Row+2:TicketNumber]!=[TicketNumber] && [Row+1:TicketNumber]=[TicketNumber],"TRUE","FALSE")

This is the output I get when I use that

[Pinky]

My Data is shown below. I need to meet two conditions which are

1.For each number the first group of the date should get updated in to updated Date field.

2.Whenever group(AA) is changed to new group(AB) for each number, the one before row date should get updated in to updated date field like shown below. Please help on this?

Number	Date	Group	Updated date
111	1/2/2017	AA	1/2/2017
111	1/12/2017	AA
111	1/3/2017	AB	1/12/2017
222	11/2/2017	BB	11/2/2017
222	11/3/2017	BB
222	11/5/2017	BD
222	12/3/2017	BE	11/3/2017
333	3/4/2017	CC	3/4/2017
333	3/5/2017	CC
333	4/4/2017	CD	3/5/2017