Add X columns based on value in cell

Question

I have a workflow where a column is created to count the number of times something happens.

I need alteryx to look at that column, find the highest value, and then add that number of columns to my output file.

For example, the column has values:

1

3

5

2

19

3

I need the output file to create 19 new columns with column-header 1 through 19.

Thanks in advance!

danilang · Answer

Hi @ramkrau

If you need to add the new columns to your existing data, Use an Append Fields tool and connect your input table to the T input and the output of @binu_acs workflow to the S input

Dan

binu_acs · Answer

@ramkrau One way of doing this

Colum_1019.yxmd

Luke_C · Answer

Hi @ramkrau

Here's an example on how to take the max value, generate a row up to the max, then crosstab those to columns. Hopefully gets you started on the right path.

New Workflow3.yxmd