5 Replies Latest reply on Sep 6, 2018 5:15 PM by Shinichiro Murakami

    count of containing words in different columns

    Armin Rauscher

      Hello,

       

      I am very new to Tableau and have tried to find a solution for my problem.

      I have a Excel sheet which i have connected to Tableau. Now i want to count occurences of a word but thorugh different columns. This means i have columns called "besch1_bez" to besch20_bez" and each column could contain as example the word "rohr". if in the 3 columns "besch5_bez", "besch6_bez" and "besch7_bez" contains the word "rohr" i would get back in the calculated field the result 3.

       

      Does someone have an idea how to do.

      Attached is the excel.

       

      Thanks Armin