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.

HotChilli's avatar
HotChilli
Community Champion
2 years ago

"a very simple comparison between all the values in a column (Job Titlle) in another table (FMS Carers) and the string literal "Agency worker"" - what's the link between 'this' table and the FMS Carers table?  There are no defined relationships in Power Query.

Can you be a bit clearer in what you are trying to do?