topic Re: How to keep data in 1 row? in App Development https://community.qlik.com/t5/App-Development/How-to-keep-data-in-1-row/m-p/118466#M8268 <HTML><HEAD></HEAD><BODY><P>I have found my mistake in data and now everything is great!</P></BODY></HTML> Fri, 28 Sep 2018 10:56:58 GMT Vasiliy_Beshentsev 2018-09-28T10:56:58Z How to keep data in 1 row? https://community.qlik.com/t5/App-Development/How-to-keep-data-in-1-row/m-p/118463#M8265 <HTML><HEAD></HEAD><BODY><P>Good day, everyone!</P><P>I have a problem with keeping data in 1 row.</P><P>So here is example what i want to achieve:</P><P><IMG __jive_id="214697" alt="2018-09-28 12_47_49-Qlik Sense Desktop.png" class="jive-image image-2" src="/legacyfs/online/214697_2018-09-28 12_47_49-Qlik Sense Desktop.png" style="height: 44px; width: 620px;" /></P><P>I load data from 2 different sql servers and some order are keep data in 1 row but sometimes it's not, and put it in 2 rows:</P><P></P><P><IMG __jive_id="214690" alt="2018-09-28 12_43_47-Qlik Sense Desktop.png" class="jive-image image-1" src="/legacyfs/online/214690_2018-09-28 12_43_47-Qlik Sense Desktop.png" style="height: 57px; width: 620px;" /></P><P>Any suggestion for help?</P></BODY></HTML> Fri, 28 Sep 2018 09:50:58 GMT https://community.qlik.com/t5/App-Development/How-to-keep-data-in-1-row/m-p/118463#M8265 Vasiliy_Beshentsev 2018-09-28T09:50:58Z Re: How to keep data in 1 row? https://community.qlik.com/t5/App-Development/How-to-keep-data-in-1-row/m-p/118464#M8266 <HTML><HEAD></HEAD><BODY><P>If the first field is the key between data from server1 and data from server2, try a left join.</P><P></P><P>Though without much knowledge of your data model, it's quite hard to give you a suggestion that might solve your issue.</P></BODY></HTML> Fri, 28 Sep 2018 09:56:44 GMT https://community.qlik.com/t5/App-Development/How-to-keep-data-in-1-row/m-p/118464#M8266 timpoismans 2018-09-28T09:56:44Z Re: How to keep data in 1 row? https://community.qlik.com/t5/App-Development/How-to-keep-data-in-1-row/m-p/118465#M8267 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Yea, first field is the key.</P><P style="font-size: 13.3333px;">It's now work for me, i'm trying this already.</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">It's very strange that some orders a ok but some others are not, and i don't understand why </SPAN><IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Fri, 28 Sep 2018 10:41:13 GMT https://community.qlik.com/t5/App-Development/How-to-keep-data-in-1-row/m-p/118465#M8267 Vasiliy_Beshentsev 2018-09-28T10:41:13Z Re: How to keep data in 1 row? https://community.qlik.com/t5/App-Development/How-to-keep-data-in-1-row/m-p/118466#M8268 <HTML><HEAD></HEAD><BODY><P>I have found my mistake in data and now everything is great!</P></BODY></HTML> Fri, 28 Sep 2018 10:56:58 GMT https://community.qlik.com/t5/App-Development/How-to-keep-data-in-1-row/m-p/118466#M8268 Vasiliy_Beshentsev 2018-09-28T10:56:58Z