Need Help

[paulwalker]

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,

[#2]

Hi,

Please go through the attachment.

Regards,

Jemimah

[paulwalker]

Please anyone can help me???

[petter · Accepted solution]

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.

[paulwalker]

Thanks Peter....

[petter]

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.

[paulwalker]

Yeah, Your right...

Thanks..

[paulwalker]

Hi Jemi,

Really, it's very helpful to me.....

Thank you so much for Quick response................