Multiple headers in Excel

[anat]

Hi Team,

My source file having multiple headers,can any one share me Extract Script based on my input data.

i have tried in many waves by referring Qlikview community links

<

Multiple header from Excel into Qlikview

multi_header_pivot_import.qvw

>

,but still i am facing problems.

[anat]

Attached source file

[#3]

Hi Ananth

Can you please share a excel file to show the exact format you want the final result to be

[anat]

i want final result in below format.

Desc	Month	Val1	Val2	Val3
x	Apr-10	1	3	6
v	Apr-10	2	4	7
as	Apr-10	3	5	67
..	..	..	..	..
.	..	..	..	..

[#5]

The format the data is in is very difficult to work with

Are you allowed to change the raw data to the format i've put in the file attached?

[anat]

Hi Chris,

Yes ,i can change date formats.

[settu_periasamy]

Hi,

May be check the attachment. (excel also) using multi_header_pivot_import.qvw

[anat]

Thanks Periasamy,

its working fine ,but in case if any values are null then its populating different values.

for Apr-10 month Val2 values are null for column  Desc (x,as).

source data:

after loading the qvw ,its prompting  below values.

Desc	Month_New	Value	Val1	Val2	Val3
as	Apr 2010		3	67	3
v	Apr 2010		2	4	7
x	Apr 2010		1	6	1

any other way to overcome this issue?

[settu_periasamy]

Yes.. i didn't notice that. When transformation in the script, if there is a null in the current column value, the previous value applied.

May be you can your null value as '0' and check, Like

[anat]

is any alternative to do in qlikview?