Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
shane_spencer
Valued Contributor

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.

Tags (2)
1 Reply
Partner
Partner

Re: Merging rows - previous / peek ?

Hello Shane:

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