Forum Discussion

Walt1010's avatar
Walt1010
Helper V
2 years ago
Solved

Comparison between String and Column Value not working

Hi, I am trying to do a very simple comparison between all the values in a column (Job Titlle) in another table (FMS Carers) and the string literal "Agency worker", but it seems to fail the test each...
Need Help
Tips and Tricks
  • HotChilli's avatar
    HotChilli
    2 years ago

    Easiest way will probably be to Merge the 2 tables on Date to return the fields you need

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Walt1010 ,

    HotChilli Thank you for your concern about this case! I agree with you.
    Have you solved your problem? If not, what HotChilli said is as below, you can follow these steps:
    Here is my sample data:

    First, merge queries:

    The output is as below:

    Expand the table:

    Then add custom columns:


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept both of the answers as the solution to help the other members find it more quickly.

Walt1010's avatar
Walt1010
Helper V
2 years ago

There are no defined links between the 2 tables. They each contain a Date field. I am trying to identify, for each date in the FMS Carers table, if there exists a matching date in the Holidays table. If such a match exists I'd like to put a flag to that effect in the FMS Cares table.