From_dataset and if-then statement HELP!

#1

cc
cc1680×523 52 KB

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?

#2

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:

Image 12-26-20 at 6.59 AM
Image 12-26-20 at 6.59 AM949×494 59.8 KB

Here is the schema:

#3

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