We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to create number of columns at same time in Formula Tool

sshind58
5 - Atom
‎02-04-2024 05:06 AM

Hello Dears,

I am working on a alteryx flow where I have added 12 Columns for 12 months of 2023 -> volume_[month]*ASP in formula tool.

Now I want to repeat this activity for 2024 and 2025, Can I add this columns and formulas by any easy trick or I need to do it manually?

Reply
0 Likes
1 REPLY 1
kamal03
9 - Comet
‎02-04-2024 06:14 AM

Hi @sshind58 

 

I have created a workflow as per my understanding, please correct me if I am wrong.

 

You can achieve this by combining the transpose tool with the cross-tab tool in Alteryx.

It will automatically create a column for future months.

 

Please let me know if it's worked for you or not. happy to help

 

 

transpose tool.png

 

Transpose tool.yxmd
Reply
Live Office Hours
Labels
Top Solution Authors
View All