From_dataset and if-then statement HELP!

I have this dataset - I want that if the ‘type of user’ is a ‘tour guide’ they will have that specific full_name from another data set called ‘tours’ that I created.
Or -
if type_of_user == tour guide then full_name == (option1,option2,option3…)
How can I do so?

Welcome @chen.nahoom!

Here is something I put together, not sure it’s exactly what you are looking for but should be a good example you can modify. If you could provide your schema link and your dataset I could go deeper on the example.

Here is the dataset:

Here is the schema:

Hi, I have same question. Plz guide us.
Thanks in advance!