Discussion Board for collaboration on QlikView Scripting.
How do we remove reverse duplicates in Qlikview?
I have a table that contains rows like AB,AC,AD and BA,BC,BD. I want to retain only the first three rows? How to do this in Qlikview using self join?
Go to Solution.
The following script works and does what want to do:
LOAD *,Ord(Pos1)+Ord(Pos2) as Value;
LOAD * Inline [
LOAD Value, FirstValue(Pos1) as Pos1,FirstValue(Pos2) as Pos2
Resident Table1 Group By Value;
Drop Field Value From Final;
DROP Table Table1;
Can you please explain little bit more with exact table structure you have.
The following is a description and solution for the problem in SQL. I am just not able to figure out how to do this in QlikView?
LOAD *,If(Pos1>Pos2,Pos2&Pos1,Pos1&Pos2) As New Inline [
Load * Resident Initial Where New <> Previous(New) Order by New,Pos1;
Drop table Initial;
Thanks a lot. This solved it.