if a field contains 1 then all values ın field return 1 else 0

[Pultayap]

Hi All,

I have real quick question. as ı mention in title. if my certain field contain 1 then ı wanna that my whole field gonna return 1 else it is gonna stay as 0 

how can ı do this ? 

[PhilipMannering · Accepted solution]

@Pultayap 

Lots of ways to do this. Check out my solution attached.

You could take the Maximum (in the Summarize Tool) and append it if your field consists entirely of 1s and values less than 1. 

[atcodedog05 · Accepted solution]

Hi @Pultayap 

Here is a workflow for the task.

Output:

Workflow:

I used summarize and max

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[AngelosPachis · Accepted solution]

Hi @Pultayap ,

I used a summarise tool to check if the column has a different value than 1. If yes, then with a formula tool I would replace the values of the whole column with 1.

Hope that helps.

Regards,

Angelos

[atcodedog05]

Happy to help 🙂 @Pultayap 

Feel free to reach out if you face any other issues 🙂

Cheers and Happy Analyzing 😀