topic Re: Finding Duplicates during load in QlikView

Finding Duplicates during load

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have two tables with same field names but with data different. The table A contains data for the status 'I' whereas the table B contains data for the status 'R' but the name might be the same in both the tables.

The issue is the Name field should be only one with status 'I' given priority. How will i avoid loading the same Name for the status 'R' ?

The table structure is this:

Table A:

ID,

Name,

Status = 'I',

Date

Concatenate

Table B:

ID,

Name.

Status = 'R'

Date

Kindly let me know if the requirement is not clear

Thanks,

Anupama Jagan

Re: Finding Duplicates during load

Anil_Babu_Samineni — Tue, 23 May 2017 17:54:30 GMT

May be use

Where Status <> 'R';

Re: Finding Duplicates during load

swuehl — Tue, 23 May 2017 17:58:21 GMT

Maybe using NOT EXISTS():

Table A:

LOAD

ID,

Name,

Status,

Date

FROM TableA;

Concatenate

LOAD

ID,

Name.

Status,

Date

FROM TableB

WHERE NOT EXISTS(Name);

Re: Finding Duplicates during load

Anonymous — Tue, 23 May 2017 18:01:20 GMT

No that will eliminate all records with status R . I want data to be there for status R . I only want to eliminate any records which is already there for status 'I' and again repeating for the status 'R'

For example if

Table A:

ID Name Status Date

1 ABC I 05/17

2 XYZ I 06/17

TableB:

ID Name Status Date

10 ABC R 08/17

20 SFG R 09/17

while concatenating i should get

ID Name Status Date

1 ABC I 05/17

2 XYZ I 06/17

20 SFG R 09/17

can you now get it?

Re: Finding Duplicates during load

Anil_Babu_Samineni — Tue, 23 May 2017 18:07:01 GMT

Seems, Working as suggested by Stefan

[Table A]:

Load * Inline [

ID, Name , Status, Date

1 , ABC, I , 05/17

2 , XYZ, I , 06/17

];

Concatenate

TableB:

LOAD * Where Not Exists (Name);

LOAD * Inline [

ID , Name , Status, Date

10 , ABC , R , 08/17

];