loading from excel

[rido1421]

Hi

how would you load this data into qlikview from an excel file?

	Cars				Bikes
Code	Toyota	Nissan	Honda	Volvo	Harley davidson	Honda	Suzuki
9	Yaris	Tida	ballade	s40	v1	CBR1000	Gsxr1000
80	Auris	x-trail	civic	s60	seven	CBR600	Gsxr600
3	Hilux	skyline	Jazz	D5	v2	Fireblade	S145

[maleksafa]

it depends how you want it to be imported, the best thing that i can think of right now it to use cross table to load this excel file.

[vardhancse]

Or y cant u ass add one more column TYPE: Cars, Bikes

So that we can load the data as normal excel sheet

[rido1421]

Ive tried the cross table function it doesnt seem to work for my requirement

is there perhaps anything to do with the Hierarchy function?

[#5]

Hi,

Load twice as cross table and concatinate both table.

create dummy field type, give it value bike in one table and car in another.

Thank

Arun Goel

[rido1421]

The data in my actual requirement is far more complex then this... I cannot edit anything on the excel spreadsheet

[#7 · Accepted solution]

Hi,

There is no other option i think, you have to hard code something to  load this format.

Attached is example how to load this, you can further elaborate as per your usage.

[rido1421]

Thank you much appreciated