Extract from excel into qlikview

[nareshthavidishetty]

Hi All,

Im attaching my sample excel file need to extract into qlikview but im unable to extract try to help me

[#2]

Hi Naresh,

can u explain a little bit more,

what is your exact requirement

[nareshthavidishetty]

thanks for the reply actually im loading that excel data into qlikview but the format is confusing like it contains headers and some columns as u can c the sample excel sheet which i attached ,kindly help me how to do

[awhitfield]

Looks like you would be better improving the format of your source file format, before attempting to load it into Qlikview.

Andhy

[nareshthavidishetty]

yea because i tried to load the original data but failed to do so that's y i want some transformations or some logic which makes meaning full data so that i can load in qlikview

[#6]

Hi naresh,

May be this is helpful for u,

naresh:

LOAD [Name of BDO] ,

     B,

     C,

     D,

     E,

     F,

     G,

     H,

     I,

     J,

     K,

     L

FROM

(ooxml, embedded labels, table is Sheet1);

left Join(naresh)

load  [Name of BDO] as nam,

  KeepChar(SubField(L,',',1),'1234567890') as [Gross Sales],

  KeepChar(SubField(L,',',2),'1234567890') as free,

  KeepChar(SubField(L,',',3),'1234567890') as salable,

  KeepChar(SubField(L,',',4),'1234567890') as [non-salable],

  KeepChar(SubField(L,',',5),'1234567890') as total

Resident naresh Where wildmatch( [Name of BDO], 'tablet*');

[nareshthavidishetty]

actually i got the excel data like below attached one kindly have a look and help me so when im loading into qlikview its giving F11,F12,so on.....

[#8]

may be this is helpfull

multi_header_pivot_import.qvw

[nareshthavidishetty]

thanks for the reply but i think its not about the pivot table what im looking is to load the data which has multiple headers kijndly have a look at the excel

[nareshthavidishetty]

Hi

I have tried what u have sent but im unbale to load the data in qlikview

give me soem idea how to do

thanks