Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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
Partner

Hello Shane:

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