topic Re: Please help with restructuring data ! in QlikView https://community.qlik.com/t5/QlikView/Please-help-with-restructuring-data/m-p/689901#M668197 <HTML><HEAD></HEAD><BODY><P>Helped me out of a big hole - thanks Gysbert</P></BODY></HTML> Fri, 24 Oct 2014 09:19:41 GMT timsaddler 2014-10-24T09:19:41Z Please help with restructuring data ! https://community.qlik.com/t5/QlikView/Please-help-with-restructuring-data/m-p/689898#M668194 <HTML><HEAD></HEAD><BODY><P>Please could i have some advice on how to restructure the data from Current Format to Required Format</P><P>Any pointers are gratefully received...</P><P>Many thanks in advance</P><P></P><P></P><P><IMG alt="WhosWHO.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/69598_WhosWHO.jpg" style="width: 620px; height: 172px;" /></P></BODY></HTML> Fri, 24 Oct 2014 08:15:53 GMT https://community.qlik.com/t5/QlikView/Please-help-with-restructuring-data/m-p/689898#M668194 timsaddler 2014-10-24T08:15:53Z Re: Please help with restructuring data ! https://community.qlik.com/t5/QlikView/Please-help-with-restructuring-data/m-p/689899#M668195 <HTML><HEAD></HEAD><BODY><P>Hi Tim</P><P></P><P>you can loop over your table 3 times to load phone, mob, mail under contact field and details fields</P><P></P><P>or use crosstable to do the same but because you have contact and Details you'll have to loop twice</P><P></P><P>best regards</P><P>Chris</P></BODY></HTML> Fri, 24 Oct 2014 08:34:55 GMT https://community.qlik.com/t5/QlikView/Please-help-with-restructuring-data/m-p/689899#M668195 2014-10-24T08:34:55Z Re: Please help with restructuring data ! https://community.qlik.com/t5/QlikView/Please-help-with-restructuring-data/m-p/689900#M668196 <HTML><HEAD></HEAD><BODY><P>What an exceedingly bad idea. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /></P><P>See attached qvw.</P></BODY></HTML> Fri, 24 Oct 2014 08:51:32 GMT https://community.qlik.com/t5/QlikView/Please-help-with-restructuring-data/m-p/689900#M668196 Gysbert_Wassenaar 2014-10-24T08:51:32Z Re: Please help with restructuring data ! https://community.qlik.com/t5/QlikView/Please-help-with-restructuring-data/m-p/689901#M668197 <HTML><HEAD></HEAD><BODY><P>Helped me out of a big hole - thanks Gysbert</P></BODY></HTML> Fri, 24 Oct 2014 09:19:41 GMT https://community.qlik.com/t5/QlikView/Please-help-with-restructuring-data/m-p/689901#M668197 timsaddler 2014-10-24T09:19:41Z