Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good Afternoon,
After hours of research, I don't understand how to solve the following problem:
I have a table with several columns, including column A which contains a character string and column B which also contains a character string.
I would like a formula that allows me to have an additional column in which there would be "TRUE" if the values entered in column A are also present in column B.
The values in column A can be present several times in column B.
Ex : if my value A2 is present in line 50 of the column B, then we return TRUE otherwise we return FALSE.
Does anyone know how to do this?
Have a good day,
Charlotte
Solved! Go to Solution.
Hi @Charlott_9,
If I correctly understand your explanation, you need a calculated column like this:
Best Regards,
Alexander
Hi @Charlott_9,
If I correctly understand your explanation, you need a calculated column like this:
Best Regards,
Alexander
Hi,
It answers my request perfectly! Thanks a lot!
Have a good day,
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |