Forum Discussion
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 space-delimited string (first word) in one of the Columns (Column B) on a seperate sheet. If the string in Column B is contained anywhere in Column A, return TRUE, else FALSE.
Any help is appreciated!
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,
1 Reply
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,