Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

If Column Name = String and Field > 0 Then 1 else 0

ChrisSpr
8 - Asteroid

Can't seem to find a way to get the column names as fields to check against in a formula. Is this just a crazy thought?

 

Thanks!

 

 

4 REPLIES 4
DavidP
17 - Castor
17 - Castor

Best way would be to look at the Transpose tool. All your column names then appear in the [Name] field and respective values in the {value] field.

 

You can then run your formula. 

 

To get back to the original format, use a CrossTab tool.

grossal
15 - Aurora
15 - Aurora

Hi @ChrisSpr,

 

use the Field Info Tool to achieve this.

 

grossal_0-1585345820411.png

 

Example:

 

Input:

grossal_1-1585345860937.png

 

 

Output:

 

grossal_2-1585345871680.png

 

 

Best

Alex

AbhilashR
15 - Aurora
15 - Aurora

@ChrisSpr - Can you give us more context on how your data is strucutred? if you are looking to get column names as rows to use them in a formula, you could start with the transpose tool.

AbhilashR_0-1585345990787.png

 

ChrisSpr
8 - Asteroid

Wow you're all fast. 

Yeah the Transpose method works just grandly.  I really over thought it.

 

🙂

Thanks everyone! Stay safe!

Labels