Read Multilevel header

[manojkulkarni]

Hi Friends,

HOw to read the below data in Qlik ? Pls anybody tell me what could be the solution.

			Age Group
			5-14			15-19
			Persons	Males	Females	Persons	Males	Females
Name	Rural/	Desc	5	6	7	8	9	10
State - MAHARASHTRA	Total	Total	496916	284261	212655	1961059	1291816	669243
State - MAHARASHTRA	Total	Illiterate	129953	68297	61656	225888	121260	104628
State - MAHARASHTRA	Total	Literate	366963	215964	150999	1735171	1170556	564615
State - MAHARASHTRA	Total	Literate but below matric/secondary	346367	203836	142531	1122865	764664	358201
State - MAHARASHTRA	Total	Matric/secondary but below graduate	0	0	0	504526	335217	169309

[bindu_apte]

Hi Manoj,

Are you extracting this data from excel or some other text file?

If you have excel file please attach the same.

[manojkulkarni]

Attached sample data

[manojkulkarni]

Attachement