i have 4410 restaurant names . I want to break this down into rows and columns matrix so that i can visualise it properly. How can i add a new field named "Row Number " that has a list from "1-440" and another field column number that has "1-10" .
so it should be as follows:
Row_no Column_No Rest_name
1 1 abc
1 2 agb
1 3 vtf
1 4 xyz
2 1 gft
2 2 lft
...........
..........
.....
Solved! Go to Solution.
Hi @gvishal9,
Different people would choose different methods but a couple of ways:
One way will be a
Another way is a couple of Multi-row formula Tools. (Set unknown rows to 0). First create
Kane
Thanks kane. It works .
And in the spirit of showing there are always different ways of finding the solution in Alteryx, you could use the RecordID tool first and then the Tile tool set to "Equal Records" with 10 Tiles. (Of course you would get an extra column that you would want to eliminate at some point.)