We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

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

Formula tool help

sekarsdream
8 - Asteroid

Hello All,

 

I have a data set in which am using a transpose tool to create a table and since it is generated from rows the columns can be some time less some time more, but i need to add a formula tool next to it . The issue am getting is when i add the column names next time if they are not there when data changes am getting errors. is there any easy way to solve this ?

1 REPLY 1
jrgo
13 - Pulsar

@sekarsdream,

 

If I understand your use case correctly, this solution should help you out. I'm also assuming that you meant to say that you used the cross tab tool since the Transpose tool takes columns and pivots to rows.

image.png

In the empty table text input tool, add fields that are needed in your formula tools.

 

Hope this helps!

 

Jimmy

Labels