Discussion Board for collaboration related to QlikView App Development.
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.
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.
Did you ever figure out how to do this? I have a very similar need. Thanks in advance.