Trying to tile or group certain rows together

[smerton]

Below is a sample of the data set I am working with on the left and the result I am looking for on the right. I have tried using the Tile tool using unique values, but can't seem to get the result. I don't want to define the number of tiles because the number of tiles needed could vary depending on the data set. Is Tile even the right tool to use here?

Data Set				Result
Store	End Cap #	Promo	End Cap Status	Tile_Num	Tile_SequenceNum
1	5	Pizza	Main	1	1
1	5	Pizza Rolls	Tie-In	1	2
2	5	Pizza	Main	1	1
2	5	Pizza Rolls	Tie-In	1	2
3	5	Pizza	Main	1	1
3	5	Pizza Rolls	Tie-In	1	2
4	5	Pizza Rolls	Main	2	1
5	5	Entrees	Main	3	1
5	5	Pizza Rolls	Tie-In	3	2

[MarqueeCrew]

can you give us a hint as to why tile_nums are being associated to the rows in your example please?

[smerton]

Stores 1, 2 and 3 have the same main and tie-in promos on the end cap, so I want to identify those as being the same end cap. Store 4 and store 5 have a different variation of promos. I want to differentiate between the 3 end cap variations.

[MarqueeCrew · Accepted solution]

@smerton, here's an approach:

1. Figure out the groupings of EndCap#, Promo & Status.

2. Join the store data to each group.

3. Output the Tiles/Groups

Does it help?

Cheers,

Mark

[smerton]

This is what I was looking for. Thanks for your help!