topic Re: Importing SparseColumns (XML in SQL) in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Importing-SparseColumns-XML-in-SQL/m-p/1030084#M1543 <HTML><HEAD></HEAD><BODY><P>Maybe this is helpful: <A _jive_internal="true" href="https://community.qlik.com/message/1010233?et=watches.email.thread#1010233" title="https://community.qlik.com/message/1010233?et=watches.email.thread#1010233">https://community.qlik.com/message/1010233?et=watches.email.thread#1010233</A></P><P></P><P>- Marcus</P></BODY></HTML> Fri, 01 Apr 2016 07:15:39 GMT marcus_sommer 2016-04-01T07:15:39Z Importing SparseColumns (XML in SQL) https://community.qlik.com/t5/Connectivity-Data-Prep/Importing-SparseColumns-XML-in-SQL/m-p/1030083#M1542 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm trying to import data that's in a SQL sparse column.&nbsp; Each SQL row contains a PK and a field filled with XML demarcating which attributes are attached to that PK.&nbsp; </P><P></P><P>e.g.&nbsp; If the attributes "IT", "VA", and "DC" belong to PK 101 then the row will have PK "101" and "&lt;IT&gt;1&lt;/IT&gt;&lt;VA&gt;1&lt;/VA&gt;&lt;DC&gt;1&lt;/DC&gt;"</P><P></P><P>Can I easily import this into QlikSense?</P></BODY></HTML> Thu, 31 Mar 2016 19:51:49 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Importing-SparseColumns-XML-in-SQL/m-p/1030083#M1542 2016-03-31T19:51:49Z Re: Importing SparseColumns (XML in SQL) https://community.qlik.com/t5/Connectivity-Data-Prep/Importing-SparseColumns-XML-in-SQL/m-p/1030084#M1543 <HTML><HEAD></HEAD><BODY><P>Maybe this is helpful: <A _jive_internal="true" href="https://community.qlik.com/message/1010233?et=watches.email.thread#1010233" title="https://community.qlik.com/message/1010233?et=watches.email.thread#1010233">https://community.qlik.com/message/1010233?et=watches.email.thread#1010233</A></P><P></P><P>- Marcus</P></BODY></HTML> Fri, 01 Apr 2016 07:15:39 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Importing-SparseColumns-XML-in-SQL/m-p/1030084#M1543 marcus_sommer 2016-04-01T07:15:39Z