topic Re: Delete dublicate rows in script in QlikView

Delete dublicate rows in script

Anonymous — Thu, 25 Jun 2015 10:03:34 GMT

Good day!

In load script i have such table:

Table:

load rowno(),

Id,

Name

from Source...

rowno()	Id	Name
1	1	Name1
2	1	Name1
3	1	Name2
4	2	Name1
5	2	Name1
6	2	Name1
7	2	Name1
8	2	Name1

How to delete in load script dublicate rows, where Id and Name have the same value?

I need get such table:

rowno()	Id	Name
1	1	Name1
2	1	Name2
3	2	Name1

Thx.

Re: Delete dublicate rows in script

alexandros17 — Thu, 25 Jun 2015 10:05:02 GMT

load distinct rowno(),

Id,

Name

from Source...

Re: Delete dublicate rows in script

pavendhan — Thu, 25 Jun 2015 10:22:06 GMT

The above load script is working as you expected

Re: Delete dublicate rows in script

vardhancse — Thu, 25 Jun 2015 10:23:35 GMT

Yes using distinct we can get only unique numbers

Re: Delete dublicate rows in script

settu_periasamy — Thu, 25 Jun 2015 10:24:16 GMT

Hi,

Try this,

Tab1:
LOAD Distinct Id & Name as Key,Id,Name;
LOAD * INLINE [
    rowno, Id, Name
    1, 1, Name1
    2, 1, Name1
    3, 1, Name2
    4, 2, Name1
    5, 2, Name1
    6, 2, Name1
    7, 2, Name1
    8, 2, Name1
];
New:
Load RowNo(),Id,Name Resident Tab1;
DROP Table Tab1;

Re: Delete dublicate rows in script

jsingh71 — Thu, 25 Jun 2015 10:24:28 GMT

Add Distinct keyword before RowNo().

Re: Delete dublicate rows in script

settu_periasamy — Thu, 25 Jun 2015 10:28:52 GMT

In the question, he mentioned, Where Id and Name have the same value?

Re: Delete dublicate rows in script

Thu, 25 Jun 2015 12:29:20 GMT

Try this.

DEL_DUP:

LOAD

RecNo() as ROW,

ID,

Name;

LOAD

Min(ROW) as ROW,

ID,

Name Group By ID,Name

;

LOAD * INLINE [

ROW, ID, Name

1, 1, Name1

2, 1, Name1

3, 1, Name2

4, 2, Name1

5, 2, Name1

6, 2, Name1

7, 2, Name1

8, 2, Name1

];