crosstbale function use

[#1]

Dear all

    I has an table like the below

project	ticketID	key	value
10001	ticket001	downAA	1
10001	ticket001	downBB	2
10001	ticket002	downAA	3
10001	ticket002	downBB	5

i want to get the result table like the below show

project	ticketID	downAA	downBB
10001	ticket001	1	2
10001	ticket002	3	5

can i use the crosstable or other QV function to realize this directly.

[ashfaq_haseeb]

Hi,

Check this

The Generic Load

Regards

ASHFAQ

[#3]

hi,

you can use pivot table in front end for this.

Regards

Vimlesh

[Anonymous]

you can directly load pivot table

Thanks

BKC

[#5]

thanks for your reply,but i am not want to show this data in the front, else do the transform  on  the qv script, is there any QV function to do this directly?