4 Replies Latest reply: Sep 17, 2012 2:18 PM by Josh Campbell RSS

    Parse CSV Data on Load

    Josh Campbell

      I need to parse data being imported from a CSV file. I have one column storing multiple values I need to break out as separate fields in QlikView. Basically the format would look like this (second column in file):

      Project:Department:Task

       

      Example values: "Consulting:Sales:WebEx"

       

      I need to capture the values "Consulting", "Sales", and "WebEx" and store them in different fields for analysis in QlikView. I would prefer that this be done at the time of load. Is there any way to break out the data using ":" as a delimiter?

       

      Thanks!