1 Reply Latest reply: Apr 1, 2016 3:15 AM by Marcus Sommer RSS

    Importing SparseColumns (XML in SQL)

    Steven Black

      Hi all,

       

      I'm trying to import data that's in a SQL sparse column.  Each SQL row contains a PK and a field filled with XML demarcating which attributes are attached to that PK. 

       

      e.g.  If the attributes "IT", "VA", and "DC" belong to PK 101 then the row will have PK "101" and "<IT>1</IT><VA>1</VA><DC>1</DC>"

       

      Can I easily import this into QlikSense?