9 Replies Latest reply: Jan 10, 2012 10:45 AM by amv34189 RSS

    How to group words separated by commas into one field within the load script

      Hello,

       

      I have an excel document with multiple columns. I have multiple words in the cells separated by commas so I have used trim(lower(subfield([Primary Cat],','))) as Category. Let's say some of the fields within Primary Cat are words like cat, dog, bird, rabbit (separated by commas). How can I, within Qlikview, make an overall category 'Animal' that says Animall = cat, dog, bird, rabbit. Is this done in the load script? I think this is pretty basic, but i am not sure how to enter it into the load script. Thank you.