Can we pivite the table using qv script?

pkkushwaha — Wed, 31 Aug 2011 10:16:43 GMT

Hi,

I am facing below problem:

base table

sid	name	sub	marks
1	a	phy	34
3	c	math	34
1	a	chem	35
2	b	chem	35
2	b	math	35
1	a	math	36
2	b	phy	45
3	c	chem	45
3	c	phy	54

o/p table

above output is possibe using pivote but due to huge amount of data (10,000,000) pivote chart option is not good.

Can we do same pivote using qv scripting?

Re: Can we pivite the table using qv script?

sbaldwin — Thu, 01 Sep 2011 12:56:50 GMT

Hi this sounds like i similar problem i saw a while back, take a look at this post :