How to loop through all the columns in the data.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
I am very new to Alteryx. I am currently working on a macro that needs to loop through each column until it reaches the end.
Can you please help me with the functionality or process we usually follow for this? Any document or video would be helpful.
Thanks
Madhu
- Labels:
- Batch Macro
- Iterative Macro
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Would definitely recommend having a read through the knowledge base on this! If you run into any specific issues then make sure to post back here!
The following video is also great as an intro:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Madhusmita_123,
What is your use case, do you have an example+data of what you want to achieve? A multi field formula maybe all you need.
There's a few approaches you could take for looping through columns, one could be transpose the data then filter the column name in a batch macro:
The community has some great videos on macros here: Interactive Lessons - Alteryx Community
HTH,
Ira
