Ability to access rows using index (like python):

[hamza_khan]

Any python user will tell you that one of the reasons why python is so powerful is the ability to access values using their indexes. It would be great if alteryx had such a system in place too, where you can access values or loop over them using their index, which can then be applied in creating new columns or calculations. 

P.S - I know we can use the python tool but I would rather see this ability built in the formula tool.

[KylieF]

Thank you for your feedback and idea! I've updated the labels on this idea to insure the correct product teams have visibility into this idea. Also since this is your first idea, I recommend checking out our Submission Guidelines, they go over the idea board process in a bit greater detail.

[patrick_digan]

@hamza_khan great idea! If you haven’t already, you may want to check out the alteryx abacus  by @jdunkerley79 . Specifically the varnum,vartext, and various varlistxxx functions may be a stepping stone towards what you’re looking for. At the very least, they’re really cool to try out.