To tile or group rows together in a certain order

[dominicmakkc]

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

[grossal · Accepted 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