Trying to create values in output file based on join tool results

[dattina2287]

I am trying to create "Yes" or "no" values in my output file based on join tool results. If there's data that is only in the L results then i want the output file to say "No." If there's data in the J results then i want the output file to say "Yes" (all within the same column).

I added a formula to create the Yes/No column in the output file but it's not working because it's only connected to to the "J" results.

Please refer to the attachment and let me know if anyone can help.

THANKS

[binuacs · Accepted solution]

@dattina2287 Connect the L and J ancho output to two formula tool, create the same field, and assign "No" to the L anchor output and "Yes" to the J anchor output, then union the result

[dattina2287 · Accepted solution]

it worked - thank you!