Read excel cross table

Fri, 01 Apr 2011 08:46:11 GMT

Hello,

i want to read this kind of Excel file into qlikview and i don't find the best way to do it ?

Someone got an idea ?

Thanks for your help.

Sophie

Read excel cross table

Fri, 01 Apr 2011 10:03:42 GMT

Bonjour Sophie,

That's not an obvious one. First you need to use the Fill tab to get the date values on all lines. Then because you have multiple embedded columns, I would do something like:

crosstable(DCTT, Data, )

LOAD

'Brigitte' as Person,

'CORA016' as Ref,

'Auxerre' as Ville,

@3 as D,

@4 as C,

@5 as TT

From Table;

crosstable(DCTT, Data, )

LOAD

'Brigitte' as Person,

'CORA016' as Ref,

'Belfort' as Ville,

@6 as D,

@7 as C,

@8 as TT

From Table;

Depending on how many columns you have (i.e. if many), then you will need to find some automated script to figure out which sets of 3 columns belong to which personname, CORA number and city. The @number is referencing a column value itself when you don't have an embedded label, and this is the only alternative to the fact that you have repeats of each column (D, C, TT), but which belong to different business entities.

This doesn't look like something that can be resolved easily. Be patient, I'm sure someone has a smart technique to help you out on this one.

topic Read excel cross table in QlikView

Read excel cross table

Read excel cross table