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
Solved! Go to 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")
Yes,formula working as expected.Thanks!
I really appreciate your help!
Regards,
Pinky
What if in case i need to update "TRUE" status for one row before last row of each Ticket Number?
Thanks,
Pinky
@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
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 |