Hi,
I have 24032 records and I need to assign them in a 10 X 10 grid in the distribruion, so that it should like the following : can someone please help me with that how to do it easily in alteryx ?
Thanks,
VJ
HI @Bharath,
I modified my above workflow to (1) base the cell in the grid on the count of items in the deciles, and (2) tie back to the original 24,032 records of random data, with the (x,y) of the grid to which each row contributed. Is that what you're going for? As long as you can replace the "Gen Random Data" area with your own data, and adjust downstream tools accordingly, you should be good to go.
Hope that helps!
Here's a start... this generates a number grid... you would still need to utilize this to reorder your grid appropriately so that a cross-tab on your data using the new offsets would have your data in the cells, rather than just the numbers from 1 to 100.
Hope it helps!
Hi @Bharath
I added the code I described, using the calculated grid locations to get actual data into the right spots in the grid.
Hope this helps.
