Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
gireesh1216
Creator II
Creator II

Problem on StoredProcedure Data

Hi Team,

I have stored procedure it contains data like this:

LOBCOMPLETECOMPLETECOMPLETE
IT111
CSE011
ECE111

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

4 Replies
ahaahaaha
Master
Master

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)

1.jpg

Regards,

Andrey

gireesh1216
Creator II
Creator II
Author

Hi Andrey,

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

gireesh1216
Creator II
Creator II
Author

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein