Join tool with missing input

Hey,

I have two files and I need below results:

1. If both files are present then I need the common values between them (i.e a Join tool)

2. If 1 of the file is missing, give the output of the file which is available.

I have been using the Join tool but it gives an error whenever 1 file is missing. Is there any other tool which could perform the required task?

Thanks!

Common Use Cases

Best Practices

Dynamic Processing

Accepted answers

BenMoss

Unfortunately I don't think @StephenR method would work here, though it is a valid way of preventing the join tool from erroring, it will mean all your records fall out of either the left or right side not the J output which you appear to be using downstream.

Presuming this is related to your other issue regarding the interface tools; check out how you can control a 'route' based on the checkbox tool using the 'detour'.

If both files are configured then perform the join, else detour around the join.

The detour essentially prevents part of the workflow from running so the 'join' error won't be reported if you detour around it when the user doesn't bring through a file.

Something like in the image below.

Ben

Detour.png

All comments

StephenRuhl

What you can do in that case is use a union before the join and create dummy fields, so if the file doesn't come through, there's still something there. Then the join will work. You can even give it an ID of -9999 or something like that to filter it out.

ayadav8

@StephenR Sorry but I am not able to follow you. I will appreciate if you could help me with this workflow. Thanks!

New Workflow2.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703