1 Reply Latest reply on Nov 23, 2018 8:05 AM by Yuriy Fal

    Selecting rows based on entry in multiple columns

    Bradley Velasquez
    Bradley Velasquez Nov 18, 2018 10:53 AM

      Hi All,

       

      I have a csv file with the following structure:

      id,class,number,grade

      001,PHY,01,A

      001,PHY,02B, A-

      004,MAT,01, C+

      003,PHY,01, B

      003,AHI, 21, A

      002, CHE, 20, P

      wherein some ids have multiple classes and numbers.

       

       

      I am trying to subset the data by ids which took a particular class, along with their entire course history

      So for example, if the class I want to filter by is PHY 01, then the subset data should be

      id,class,number,grade

      001,PHY,01,A

      001,PHY,02B, A-

      003,PHY,01, B

      003,AHI, 21, A

      since student 001 and 003 took both took PHY 01.

       

      I've tried using filtering by the desired class, but this limits the scope of the data I want.

      Does anyone have any suggestions on how to do this in Tableau prep?