topic Re: Problem on StoredProcedure Data in QlikView https://community.qlik.com/t5/QlikView/Problem-on-StoredProcedure-Data/m-p/1344645#M846436 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May be like this as variant</P><P></P><P>Directory;</P><P>CrossTable(Sign_COMPLETE, VALUE)</P><P>LOAD *</P><P>FROM</P><P>[16.xlsx]</P><P>(ooxml, embedded labels, table is Sheet1);</P><P></P><P>Result (in attached files)</P><P><IMG alt="1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/159090_1.jpg" style="height: auto;" /></P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Wed, 05 Apr 2017 11:12:49 GMT ahaahaaha 2017-04-05T11:12:49Z Problem on StoredProcedure Data https://community.qlik.com/t5/QlikView/Problem-on-StoredProcedure-Data/m-p/1344644#M846435 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>I have stored procedure it contains data like this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>LOB</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>COMPLETE</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>COMPLETE</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>COMPLETE</STRONG></TH></TR><TR><TD style="padding: 2px;">IT</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">CSE</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">ECE</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>How to load stored procedure data with similar kind of fields into qlikview...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Problem-on-StoredProcedure-Data/m-p/1344644#M846435 gireesh1216 2020-11-25T16:16:04Z Re: Problem on StoredProcedure Data https://community.qlik.com/t5/QlikView/Problem-on-StoredProcedure-Data/m-p/1344645#M846436 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May be like this as variant</P><P></P><P>Directory;</P><P>CrossTable(Sign_COMPLETE, VALUE)</P><P>LOAD *</P><P>FROM</P><P>[16.xlsx]</P><P>(ooxml, embedded labels, table is Sheet1);</P><P></P><P>Result (in attached files)</P><P><IMG alt="1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/159090_1.jpg" style="height: auto;" /></P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Wed, 05 Apr 2017 11:12:49 GMT https://community.qlik.com/t5/QlikView/Problem-on-StoredProcedure-Data/m-p/1344645#M846436 ahaahaaha 2017-04-05T11:12:49Z Re: Problem on StoredProcedure Data https://community.qlik.com/t5/QlikView/Problem-on-StoredProcedure-Data/m-p/1344646#M846437 <HTML><HEAD></HEAD><BODY><P>Hi Andrey,</P><P></P><P>I am using STORE PROCEDURE.In excel data it is very easy to change.</P></BODY></HTML> Wed, 05 Apr 2017 12:18:02 GMT https://community.qlik.com/t5/QlikView/Problem-on-StoredProcedure-Data/m-p/1344646#M846437 gireesh1216 2017-04-05T12:18:02Z Re: Problem on StoredProcedure Data https://community.qlik.com/t5/QlikView/Problem-on-StoredProcedure-Data/m-p/1344647#M846438 <HTML><HEAD></HEAD><BODY><P>Hi Andrey,</P><P></P><P>If we load data from excel field field names changingCOMPLTED1,COMPLETED2 ....ECT</P></BODY></HTML> Wed, 05 Apr 2017 12:51:04 GMT https://community.qlik.com/t5/QlikView/Problem-on-StoredProcedure-Data/m-p/1344647#M846438 gireesh1216 2017-04-05T12:51:04Z Re: Problem on StoredProcedure Data https://community.qlik.com/t5/QlikView/Problem-on-StoredProcedure-Data/m-p/1344648#M846439 <HTML><HEAD></HEAD><BODY><P>The stored procedure cannot return multiple fields with the same name (at least not in any DBMS that I have worked with). So your data must look different to what you have posted.</P></BODY></HTML> Wed, 05 Apr 2017 13:06:43 GMT https://community.qlik.com/t5/QlikView/Problem-on-StoredProcedure-Data/m-p/1344648#M846439 jonathandienst 2017-04-05T13:06:43Z