CrossTable in Qlik sense

[LP27]

Hi Everyone,

I need to achieve this in load script using CrossTable function. Not sure if this can be done for the below scenario

my  sample dataset looks like this - 

Id	Name	Title	Value
1	TMO	Sent	Yes
1	TMO	Status	Transit
1	TMO	Days Taken	3
2	PRO	Sent	No
2	PRO	Status	Dispatched
2	PRO	Days Taken	5

Now I need to achieve into this - 

ID	Name	Sent	Status	Days Taken
1	TMO	Yes	Transit	3
2	PRO	No	Dispatched	5

How do i get this with Cross Table or is there any other way to get the above output.

Kindly assist me here!

Thanks in advance!!!!

[MayilVahanan]

HI @LP27 

Actually, you need to use Generic load. Please refer the doc for it.

https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470