Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
timsaddler
Contributor II

Please help with restructuring data !

Please could i have some advice on how to restructure the data from Current Format to Required Format

Any pointers are gratefully received...

Many thanks in advance

WhosWHO.jpg

1 Solution

Accepted Solutions

Re: Please help with restructuring data !

What an exceedingly bad idea.

See attached qvw.


talk is cheap, supply exceeds demand
3 Replies
Not applicable

Re: Please help with restructuring data !

Hi Tim

you can loop over your table 3 times to load phone, mob, mail under contact field and details fields

or use crosstable to do the same but because you have contact and Details you'll have to loop twice

best regards

Chris

Re: Please help with restructuring data !

What an exceedingly bad idea.

See attached qvw.


talk is cheap, supply exceeds demand
timsaddler
Contributor II

Re: Please help with restructuring data !

Helped me out of a big hole - thanks Gysbert

Community Browser