0 Replies Latest reply on Oct 26, 2018 4:40 AM by Manish singh

    Table Calculation

    Manish singh

      Hi all

       

      I want to create a column (category) as shown below................as i have done this in excel using commands like 

      =IF(SUM(COUNTIF(B2,{"*blog*","*student*","*articles*","*forum*","*courses*","*where*"})),"Editorial","")

      =IF(SUM(COUNTIF(B2,{"/events*"}))," Events"," ")

      IF(SUM(COUNTIF(B3,{"/universities/")), "Universitites"," ")...etc

       

       

      Basicallly, i want o create only a  calculated field  named category in tableau which would do this..........in one go....

       

      Help required

       

       

       

          

      Event CategoryPageUnique EventsCategory
      CTA-Join Us Attempt/67Home
      CTA-Join Us Attempt/university-rankings/asian-university-rankings/201962Editorial
      CTA-Join Us Attempt/university-rankings/world-university-rankings/201951Editorial
      CTA-Join Us Attempt/cookies-policy15Others
      CTA-Join Us Attempt/university-rankings18Rankings
      CTA-Join Us Completed/17Home
      CTA-Join Us Attempt/university-rankings/world-university-rankings/201812Editorial
      CTA-Join Us Attempt/university-finder/university/match/study-destination2Universities
      CTA-Join Us Attempt/university-rankings/asian-university-rankings/201812Editorial
      CTA-Join Us Attempt/forum/postgraduate-courses-subjects/looking-full-scholarship-study-nursing-canada3Editorial
      CTA-Join Us Attempt/university-rankings-articles/asian-university-rankings/top-10-universities-asia-20197Editorial
      CTA-Join Us Attempt/student-info/scholarships/international-scholarships-students-developing-countries7Editorial
      CTA-Newsletter Attempt/university-rankings/asian-university-rankings/201910Editorial
      CTA-Join Us Attempt/student-info/health-and-support/exam-preparation-ten-study-tips5Editorial
      CTA-Join Us Attempt/student-info/scholarship-advice/scholarships-study-canada5Editorial
      CTA-Join Us Attempt/student-info/scholarship-advice/scholarships-study-germany7Editorial
      CTA-Join Us Attempt/university-rankings/university-subject-rankings/2018/engineering-technology5

      Editorial