Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
when i try loading an excel file into qlikview that the header is appering but i want thee fields into table ..
Then Load all this way
Tab1:
LOAD NO.,
Governate,
Willayat
......
FROM
(ooxml, explicit labels, header is 1 lines, table is Sheet1);
Concatenate(Tab1):
..
After 10 concatenate you get single table and then
Store Tab1 into TableName.qvd;
Regards
Anand
He:
LOAD * INLINE [
F1, F2
1, 2
22, 44
];
He2:
45455rgcfdf, 5
22, 64
here once show me how to write....
Hi,
Or by single syntax you can load all the 10 tables
TableName:
LOAD *
(ooxml, explicit labels, header is 1 lines, table is [$(*)]);
Store TableName into TableName.qvd;
Try with
NoConcatenate
noconcatenate
New:
Load * Resident He;
DROP Table He;
Load F1,F2 Resident He2;
DROP Table He2;
i m having excel sheets of different governerates and how can in single syntax ..
anand can u give me u r mailid i m fed up with so many queries .
thanqq very much i will make use of this resident sytax its fine here we have to write all fields right ......
Please close the thread by appropriate answer selected for references. For new question post the new thread.
Concatenate(He)
Store He into He.qvd (qvd);
drop table He;
i want to show u one pivot table query if u r free.... mail?
Yes right this way all 10 or you better you can load all table at once.
