FavoriteTableau Community Forums Member (Inactive) (Salesforce) asked in #AllNov 16, 2023, 11:20 AMI would like to know the alternative for below excel expressions. 1) IFERROR(MATCH(""*Apple*"",[[Fruits]],0),0) 2)COUNTIF(A.SRC[[#All],[SRC]],[Apple])3 answersSortSort by DateSort by Most HelpfulSort by DateLoad more comments...Chris McClellan (Visualisedata Pty Ltd)Nov 16, 2023, 10:57 PMIs this a ChatGPT response ? SEARCH is not a Tableau function at all. It would be CONTAINS([Fruits], 'Apple') ... remember that's all Case Sensitive.Add a commentWrite an answer...BoldItalicUnderlineStrikethroughBulleted ListNumbered ListAdd linkCode blockInsert imageAttach filesLink URLCancelSave0/9000Reply
Chris McClellan (Visualisedata Pty Ltd)Nov 16, 2023, 10:57 PMIs this a ChatGPT response ? SEARCH is not a Tableau function at all. It would be CONTAINS([Fruits], 'Apple') ... remember that's all Case Sensitive.