Forum Discussion
Solved
Comparing strings between two separate sheets for True/False result
Hi there, new to BI and loving it so far. I would like to do the following: Create a custom column on one sheet, which compares the string in one of the Columns (Let's say Column A) against the s...
According to your description, you have "find string" in Column A, then you want to search Column A, if the delimited string is included in any Column A entry, then return TRUE, otherwise FALSE. Right?
In this scenario, you can put SEARCH() function into SUMX() to get the total index for each delimited string. Please see my sample below:
Column = IF(SUMX(String,SEARCH(Word[Word],String[String],,0))>0,1,0)
Regards,
According to your description, you have "find string" in Column A, then you want to search Column A, if the delimited string is included in any Column A entry, then return TRUE, otherwise FALSE. Right?
In this scenario, you can put SEARCH() function into SUMX() to get the total index for each delimited string. Please see my sample below:
Column = IF(SUMX(String,SEARCH(Word[Word],String[String],,0))>0,1,0)
Regards,