5 Replies Latest reply on Apr 13, 2017 11:52 AM by Kaz Shakir

    Looking for a function/workaround similar to "Find()" in excel

    Impashree Shetty

      Hi All,

       

      Need a help again on finding functions/workaround in tableau which is similar to "Find" function in excel.

       

      I will try my best to explain what i am looking for (also attaching the excel with the data and calculations )

       

      Basically in my data, i have a column called RBS and OU.

      structure of RBS looks like this

      Ex:

      OU                     RBS

      E                       Leader

      P                       Leader.Sr Director Supply Chain

      E                       Leader.Sr Director Supply Chain.Director ERP/CLS

      P                       Leader.Sr Director Supply Chain.Director ERP/CLS.Senior Manager ERP-SAP

      P                       Leader.Sr Director Supply Chain.Director ERP/CLS.Senior Manager ERP-SAP.Team ERP-SAP

       

      I want to search for a string "Leader" in entire column of RBS for each of the Resource (which is one more column in my data) and whenever there is a match then count the number of "E" and "P" in column OU. In the above case, E Count will be 2 and P Count will be 3 (because Leader is there in all the rows).

       

      Please find the attached excel for detailed description.

       

      Thanks in Advance.