Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I Need Help,
I have one Excel datasource.. like this
ABC | Employee | Employee1 | 75281 | |
Employee2 | 40930 | |||
Department | Department1 | 40711 | ||
DEpartment2 | 41037 | |||
BCA | Employee | Employee1 | 130256 | |
Employee2 | 53922 | |||
Department | Department1 | 2319 | ||
DEpartment2 | 18469 | |||
CBA | Employee | Employee1 | 2480275 | |
Employee2 | 976329 | |||
Department | Department1 | 3056 | ||
DEpartment2 | 19556 |
Thanks in Advance....
PFA,
The solution Jemimah gave you is fine for the CROSSTABLE part and you could just quick-fix that with adding this to the end of his load script:
Tab2:
NOCONCATENATE LOAD
Code,
Pick( Match( Col, 'Employee1', 'Employee2' , 'Department1', 'Department2' ) , 'Total Customer','Tot Unique','Total Dept' , 'Tot Dept Unique' ) AS Col,
Value,
Column
RESIDENT
Tab1;
DROP TABLE Tab1;
And it will work fine. I attached a modifed QVW. But I used a BINARY load since I didn't have the source Excel file.
Hi,
Please go through the attachment.
Regards,
Jemimah
Please anyone can help me???
The solution Jemimah gave you is fine for the CROSSTABLE part and you could just quick-fix that with adding this to the end of his load script:
Tab2:
NOCONCATENATE LOAD
Code,
Pick( Match( Col, 'Employee1', 'Employee2' , 'Department1', 'Department2' ) , 'Total Customer','Tot Unique','Total Dept' , 'Tot Dept Unique' ) AS Col,
Value,
Column
RESIDENT
Tab1;
DROP TABLE Tab1;
And it will work fine. I attached a modifed QVW. But I used a BINARY load since I didn't have the source Excel file.
Thanks Peter....
Actually it was Jemimah that solved the crosstable for you so please mark his contribution as helpful and like his solution too so he gets some points for it.
Yeah, Your right...
Thanks..
Hi Jemi,
Really, it's very helpful to me.....
Thank you so much for Quick response................