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.

[florentina_doga]

hi ananth

try this

aa:

LOAD @1 as data,  

     @2 as val,

     @3 as val1,

     @4 as val2,

     @5 as val3

FROM

[Copy of Book1-3.xlsx]

(ooxml, no labels, table is Sheet1, filters(

Replace(1, bottom, StrCnd(null)),

Transpose(),

Rotate(left),

Rotate(right),

Transpose(),

Transpose(),

Replace(1, top, StrCnd(null))

));

bb:

load distinct

data, val as value

resident aa where upper(val)<>'DESC' and len(val)<>0;

left join(bb)

load

data, val as value, val1 as amount, 'x' as desc

resident aa where upper(val)<>'DESC' and len(val)<>0;

Concatenate(bb)

load

data, val as value, val2 as amount, 'y' as desc

resident aa where upper(val)<>'DESC' and len(val)<>0;

Concatenate(bb)

load

data, val as value, val3 as amount, 'as' as desc

resident aa where upper(val)<>'DESC' and len(val)<>0;

drop table aa;

hope this help.