Cross Tab - dynamic input for "Values for New Columns"

I want the "Values for New Columns" field in the Cross Tab tool to change depending on a certain input; essentially it would be ideal to put a formula in there (e.g. Values for New Columns = [Issue Age]) . I don't think anything like this is possible, so I'm wondering if there's a workaround.

I attached an example. In the Text Input tool you'll see a column for Issue Age where each row equals 60. Then, in the cross tab tool, I want to transform the column equal to 60 because it is the issue age. In my example, I manually set "Values for New Columns" to 60. If the issue age were to change, is there some way to change "Values for New Columns" to be equal to the issue age without doing it manually?

Alteryx example.yxmd

Workflow

Accepted answers

echuong1

If you pivot your data so your data is in a name-value format, you can use the issue age as a dynamic filter. I used a transpose to pivot my data, then used a filter to identify any row where Name = Issue Age. This would identify any value that was originally associated with the corresponding age column. I then used a cross-tab to pivot my data back.

Alteryx example (1) (1).yxmd

All comments

Qiu

@jgiacomazzi

Maybe dynamic Select?

jgiacomazzi

How could I use this tool without manually inputting '60' though? And automatically setting it to the issue age column?

echuong1

Alteryx example (1) (1).yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703