Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Not applicable

Importing SparseColumns (XML in SQL)

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?

1 Reply

Re: Importing SparseColumns (XML in SQL)

Community Browser