2 Replies Latest reply: Apr 20, 2016 8:19 AM by Vally Prasuna Bhamidipati RSS

    create a list based on multiple column values

    Vally Prasuna Bhamidipati

      Hi, I have a requirement to create a list based on multiple column values

      Eg:

      I have this data

      Column1Column2Column3RowNo
      abcghidef1
      jklabcdef2
      jkldefxyz3
      ghijklabc4
      mnoabcjkl5

       

      Now, I need  a dropdown with values abc,def,ghi,jkl,mno,xyz.

      If I select any value in the dropdown I  need to get all the rows that have the value in any of the columns-1,2,3

      i.e, if I select abc in the dropdown, I need to get 1,2,4,5 rows.

      if I select def, I need to get the rows 1,2,3