Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a source excel file :
Required format :
I want to load this source file into Qlikview as :
I am trying to do this using Crosstable but no success.
Please help
Thanks
BKC
MainSource:
LOAD A,
B,
C,
D,
E,
F,
G,
H,
I,
J,
K,
L,
M,
N
FROM
Crosstable_Sample.xlsx
(ooxml, no labels, header is 4 lines, table is Sheet2);
CrossTable:
LOAD
A as AppType,
B as AppName,
'01/01/2015' as AppDate,
C as Sched,
D as Avail,
E as AvailPct
Resident
MainSource;
Concatenate LOAD
A as AppType,
B as AppName,
'01/02/2015' as AppDate,
F as Sched,
G as Avail,
H as AvailPct
Resident
MainSource;
Concatenate LOAD
A as AppType,
B as AppName,
'01/03/2015' as AppDate,
I as Sched,
J as Avail,
K as AvailPct
Resident
MainSource;
Concatenate LOAD
A as AppType,
B as AppName,
'01/04/2015' as AppDate,
L as Sched,
M as Avail,
N as AvailPct
Resident
MainSource;
drop table MainSource;
try this,
1. load ur excel data as it is.
2. use pivot table
3. drag ur month column as row,tht will bring ur expected result!
Shiva ,
This will not solve my problem. If I want to sum(Down) for all the month that can not be achieved without loading data in qlikview as given format .
find attached and change the lable accordingly in rows and columns
MainSource:
LOAD A,
B,
C,
D,
E,
F,
G,
H,
I,
J,
K,
L,
M,
N
FROM
Crosstable_Sample.xlsx
(ooxml, no labels, header is 4 lines, table is Sheet2);
CrossTable:
LOAD
A as AppType,
B as AppName,
'01/01/2015' as AppDate,
C as Sched,
D as Avail,
E as AvailPct
Resident
MainSource;
Concatenate LOAD
A as AppType,
B as AppName,
'01/02/2015' as AppDate,
F as Sched,
G as Avail,
H as AvailPct
Resident
MainSource;
Concatenate LOAD
A as AppType,
B as AppName,
'01/03/2015' as AppDate,
I as Sched,
J as Avail,
K as AvailPct
Resident
MainSource;
Concatenate LOAD
A as AppType,
B as AppName,
'01/04/2015' as AppDate,
L as Sched,
M as Avail,
N as AvailPct
Resident
MainSource;
drop table MainSource;