Hii experts,
I have been doing some data analysis on a robot patrolling record.
For some reason, I try to connect the robot entry & exit record and group the data by " each combination of journey id & robot no." i.e. for each robot they could have different journey id for each time of travelling.
The data is in such way
joruney id | robot no. | area | start time | end time |
1 | F9303 | A | 1/12/2019 20:14 | 1/12/2019 20:33 |
3 | M1605 | B | 4/12/2019 20:08 | 4/12/2019 20:17 |
3 | G5961 | D | 3/12/2019 13:26 | 3/12/2019 13:34 |
3 | G5961 | H | 3/12/2019 14:34 | 3/12/2019 14:55 |
3 | G5961 | J | 3/12/2019 14:55 | 3/12/2019 15:05 |
3 | G5961 | D | 3/12/2019 15:05 | 3/12/2019 15:12 |
3 | G5961 | E | 3/12/2019 15:15 | 3/12/2019 15:19 |
3 | D8321 | G | 5/12/2019 12:36 | 5/12/2019 12:39 |
3 | D8321 | F | 5/12/2019 12:54 | 5/12/2019 12:55 |
4 | G1426 | C | 4/12/2019 16:44 | 4/12/2019 16:45 |
4 | G1426 | A | 4/12/2019 16:48 | 4/12/2019 16:58 |
4 | G1426 | J | 4/12/2019 16:58 | 4/12/2019 16:59 |
4 | G1426 | C | 1/12/1900 17:03 | 4/12/2019 17:07 |
4 | G1426 | B | 4/12/2019 17:07 | 4/12/2019 17:10 |
4 | G1426 | H | 4/12/2019 17:14 | 4/12/2019 17:23 |
6 | M3381 | A | 2/12/2019 09:59 | 2/12/2019 10:00 |
6 | M3381 | B | 2/12/2019 10:00 | 2/12/2019 10:02 |
6 | M3381 | I | 2/12/2019 10:02 | 2/12/2019 10:06 |
6 | M3381 | A | 2/12/2019 10:06 | 2/12/2019 10:10 |
6 | M3381 | F | 2/12/2019 10:10 | 2/12/2019 10:18 |
I tried to use tile tool with "Tile method>unique value", I chose group by columns but in my case I just don't think any of the column should be ticked as "unique column".
I was supposed my result would look it this:
joruney id | robot no. | area | start time | end time | Tile_Num | Tile_SequenceNum |
1 | F9303 | A | 1/12/2019 20:14 | 1/12/2019 20:33 | 1 | 1 |
3 | M1605 | B | 4/12/2019 20:08 | 4/12/2019 20:17 | 2 | 1 |
3 | G5961 | D | 3/12/2019 13:26 | 3/12/2019 13:34 | 3 | 1 |
3 | G5961 | H | 3/12/2019 14:34 | 3/12/2019 14:55 | 3 | 2 |
3 | G5961 | J | 3/12/2019 14:55 | 3/12/2019 15:05 | 3 | 3 |
3 | G5961 | D | 3/12/2019 15:05 | 3/12/2019 15:12 | 3 | 4 |
3 | G5961 | E | 3/12/2019 15:15 | 3/12/2019 15:19 | 3 | 5 |
3 | D8321 | G | 5/12/2019 12:36 | 5/12/2019 12:39 | 4 | 1 |
3 | D8321 | F | 5/12/2019 12:54 | 5/12/2019 12:55 | 4 | 2 |
4 | G1426 | C | 4/12/2019 16:44 | 4/12/2019 16:45 | 5 | 1 |
4 | G1426 | A | 4/12/2019 16:48 | 4/12/2019 16:58 | 5 | 2 |
4 | G1426 | J | 4/12/2019 16:58 | 4/12/2019 16:59 | 5 | 3 |
4 | G1426 | C | 1/12/1900 17:03 | 4/12/2019 17:07 | 5 | 4 |
4 | G1426 | B | 4/12/2019 17:07 | 4/12/2019 17:10 | 5 | 5 |
4 | G1426 | H | 4/12/2019 17:14 | 4/12/2019 17:23 | 5 | 6 |
6 | M3381 | A | 2/12/2019 9:59 | 2/12/2019 10:00 | 6 | 1 |
6 | M3381 | B | 2/12/2019 10:00 | 2/12/2019 10:02 | 6 | 2 |
6 | M3381 | I | 2/12/2019 10:02 | 2/12/2019 10:06 | 6 | 3 |
6 | M3381 | A | 2/12/2019 10:06 | 2/12/2019 10:10 | 6 | 4 |
6 | M3381 | F | 2/12/2019 10:10 | 2/12/2019 10:18 | 6 | 5 |
Is Tile even the right tool to use here? Or should it be another tool like multi row formula?
Thanks in advance
Solved! Go to Solution.
Hi @dominicmakkc.
this was trickier than I thought it was.
I wasn't able to figure out a way using the Tile tool, but it's pretty simple using the Multi-Row-Formula Tool.
I have attached the sample workflow.
If this solved you problem, please consider to accept it as a solution or drop another question if it doesn't.
Alex