Problem on StoredProcedure Data

[gireesh1216]

Hi Team,

I have stored procedure it contains data like this:

LOB	COMPLETE	COMPLETE	COMPLETE
IT	1	1	1
CSE	0	1	1
ECE	1	1	1

How to load stored procedure data with similar kind of fields into qlikview...

[ahaahaaha]

Hi,

May be like this as variant

Directory;

CrossTable(Sign_COMPLETE, VALUE)

LOAD *

FROM

[16.xlsx]

(ooxml, embedded labels, table is Sheet1);

Result (in attached files)

Regards,

Andrey

[gireesh1216]

Hi Andrey,

I am using STORE PROCEDURE.In excel data it is very easy to change.

[gireesh1216]

Hi Andrey,

If we load data from excel field field names changingCOMPLTED1,COMPLETED2 ....ECT

[jonathandienst]

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.