Difference in data loaded

[rassanbekov]

Hello!

i have two data set with key in ID:

the total number of lines in both data sets are 502,547.

However, when I load in Qlik, the total number of lines in straight table shown as 502,549.

How can I identify the difference why click loads more than actually exists?

Maybe any scripts exists to identify?

[antoniotiman]

This is because there are 2 duplicated ID

7760578787-7770977701

Regards,

Antonio

[rassanbekov]

Oh.. great!

How did you identified these duplicates... Please explain your approach

[effinty2112 · Accepted solution]

Hi Ruslan,

this script will give the row no in the source of the second occurrence of the duplicate ID.

[Table 1]:

LOAD ID,

     MONTH0

FROM

[Table 1.xlsx]

(ooxml, embedded labels, table is Лист1);

Inner Join([Table 1])

LOAD

RowNo(),

FirstSortedValue(ID,RecNo(),2) as ID

Resident [Table 1]

Group by ID;

ID	RowNo()	MONTH0
7760578787	284323	0
7770977701	38927	0

Good luck

Andrew

[rassanbekov]

Could you please share your qvw file since the error occurs when I use your scripts...

[antoniotiman]

I have loaded Tables with (or without) Join, then

=Concat({<ID={'=Count(ID) > 1'}>} DISTINCT ID,'-')

[petter]

Do determine repeated use of ID on each table you can simple load the two tables like this and have a straight table to show the IDs that occur more than once: