Qlik Sense Load Script: Remove both rows if two such rows have same value in one column.

[sban]

Hi, I have a table of a similar structure as below:

col 1	col2	col3	col4/ID	col5
xyz	month1	qw	abc	l
abcdef	month2	we	abc	k
adf	month4	er	x	j
asd	month4	rt	y	h
asd	month8	ty	z	g
asd	month1	yu	K	f

I have loaded this in Qlik. Col4 is my ID field and I want to create a new table from this table, using resident, where I want to remove both the rows having duplicate value in col4 , and so on for similar such occurrences in this table.

Output table will be like this:

col 1	col2	col3	col4/ID	col5
adf	month4	er	x	j
asd	month4	rt	y	h
asd	month8	ty	z	g
asd	month1	yu	K	f

Requesting your assistance as to how I can make this possible, since load distinct will not help this case.

Thanks and Regards.

[Digvijay_Singh · Accepted solution]

Create temp table with only Col4/ID and Count(COl4/ID) group By Col4/ID. Then left join this temp table with the first table. In the final load use Where clause and only load if new count field = 1