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

[ChrisSpr]

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!

[DavidP · Accepted solution]

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]

Hi @ChrisSpr,

use the Field Info Tool to achieve this.

Example:

Input:

Output:

Best

Alex

[AbhilashR]

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

[ChrisSpr]

Wow you're all fast. 

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

🙂

Thanks everyone! Stay safe!