8 Replies Latest reply: Feb 17, 2014 12:41 AM by Chanel Choo RSS

    Combination of multiple fields - show in a listbox

      Dear community,

       

      I have a table in this format where the interests are separated in 3 columns, I want to show all in one listbox, so i have a script as shown below, then i can view all in a listbox.

      However, when i select any one of interests, it doesn't affect to the chart. Any one knows how to combine 3 fields into one fields?

       

      f_nameinterest_1interest_2interest_3
      aaMusicBooksPhotography
      bbIndoor SportGardeningFashion
      ccGadgetsTennis ClubChatting
      ddMusicTravelPhotography

       

      Script

      Piper:

      LOAD     name,

          interest_1,

          interest_2,

          interest_3

      FROM

      [C:abc.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      Interest1:

      Load interest_1 as AllInterest

      Resident Piper;

       

      Interest2:

      Load interest_2 as AllInterest

      Resident Piper;

       

      Interest3:

      Load interest_3 as AllInterest

      Resident Piper;

       


      Thanks,

      Chanel