Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shane_spencer
Specialist
Specialist

Merging rows - previous / peek ?

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.

i.e. For those 5 fields where TRANS_REF_LINE is 001 they want to be merge with the above row.

move data up a line.PNG

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.

1 Reply
pnn44794
Partner - Specialist
Partner - Specialist

Hello Shane:

Did you ever figure out how to do this?  I have a very similar need.  Thanks in advance.