expression column with list compare to given list to replace with desired value
Hi,is there a method through add new formula to column for issue below?
I have a column that is list value and I want to compare to given list, if element from list in column match to given list then replace that single element with "1". Below are example. The given list is {"aa", "app", "b", "pp", "zzzz"}