1 Reply Latest reply: Sep 11, 2012 8:57 PM by John Lifter RSS

    Turn a delimited string into table fields - import script

    Eric VanCurler

      Hello QlikView Community,

       

        Some of our data that needs to be loaded into Qlik is stored in a string (single field) as such:

       

        Height=60,Width=30,Color=Red, etc... (attribute=value,attribute=vale...)

       

        I need help with transforming this data into a single table that has a field for each of the attributes. 

       

      So, for example, these two strings turned into the below table.

      String1: "Height=60,Width=30,Color=Red"

      String2: "Color=White,Height=50,Width=40"  (note that the order of the attributes in the string do not match from string to string).

       

       

      HeightWidthColor
      6030Red
      5040White

       

      I'm not sure where to begin on this. If possible it would be best to have a table with dynamic columns.  If that is not readily feasible then I could build a static table with all the attributes pre-defined if that is required.

       

      Any help would be greatly appreciated!

       

      Thanks,

      Eric