Hello everyone,

This is my database.
Each org_uuid is matched with a specific investor_uuid. This are real matches.
Then each org_uuid has its own employee and each investor_uuid has its own partners.

Array

I want to build a counterfactual sample of all matches that did not happen. To do this I'm trying to mix the org_uuid and the investor_uuid, i.e, for the first org_uuid i want to match all the investor_uuid; then for the second org_uuid i want to match all the investor_uuid, and so on.
After that i want to rematch to each org_uuid, its employees and to each investors_uuid all its partners.

Each counterfactual march should be marked with 0, while each real match with 1, so that they can be recognised.

If anyone can help me, it would be really appreciated!

Thank you in advance!

Charlotte