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

Question

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?

kamal03 · Answer

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.yxmd