topic Merging rows - previous / peek ? in QlikView https://community.qlik.com/t5/QlikView/Merging-rows-previous-peek/m-p/72289#M11963 <HTML><HEAD></HEAD><BODY><P>I've got some data that I've cleansed but at the point where I need to merge two rows or in Excel terms move some values up a row.</P><P></P><P>i.e. For those 5 fields where TRANS_REF_LINE is 001 they want to be merge with the above row.</P><P><IMG alt="move data up a line.PNG" class="jive-image image-1" src="/legacyfs/online/194189_move data up a line.PNG" style="height: 112px; width: 620px;" /></P><P></P><P>If it helps the TRANS_REF_DOC field is unique. What's the easiest way of doing that? I've got an inkling that it may be using Previous or Peek but unsure of the best way.</P></BODY></HTML> Thu, 22 Feb 2018 12:38:57 GMT shane_spencer 2018-02-22T12:38:57Z Merging rows - previous / peek ? https://community.qlik.com/t5/QlikView/Merging-rows-previous-peek/m-p/72289#M11963 <HTML><HEAD></HEAD><BODY><P>I've got some data that I've cleansed but at the point where I need to merge two rows or in Excel terms move some values up a row.</P><P></P><P>i.e. For those 5 fields where TRANS_REF_LINE is 001 they want to be merge with the above row.</P><P><IMG alt="move data up a line.PNG" class="jive-image image-1" src="/legacyfs/online/194189_move data up a line.PNG" style="height: 112px; width: 620px;" /></P><P></P><P>If it helps the TRANS_REF_DOC field is unique. What's the easiest way of doing that? I've got an inkling that it may be using Previous or Peek but unsure of the best way.</P></BODY></HTML> Thu, 22 Feb 2018 12:38:57 GMT https://community.qlik.com/t5/QlikView/Merging-rows-previous-peek/m-p/72289#M11963 shane_spencer 2018-02-22T12:38:57Z Re: Merging rows - previous / peek ? https://community.qlik.com/t5/QlikView/Merging-rows-previous-peek/m-p/1555616#M440672 <P>Hello Shane:</P><P>Did you ever figure out how to do this?&nbsp; I have a very similar need.&nbsp; Thanks in advance.</P> Tue, 12 Mar 2019 19:10:54 GMT https://community.qlik.com/t5/QlikView/Merging-rows-previous-peek/m-p/1555616#M440672 pnn44794 2019-03-12T19:10:54Z