Values are repeating in one column in Straight Table In Qlik Sense

[MS90]

1)Please find below details    after loading data from data base to Qlik one column (Sold Code)is getting repeated values due to another columns (Sold ID) attached below details and

2)also due to more than 1million rows straight table is loading very slow how to optimise it by for loading data in table like initially only showing first 10000rows as pagination is not available in QS

Table in data base
Barcode(Keyfield)	Name	Country	Sold Ref	Sold Id
1	Gold	Canada	A1	100
1	Gold	Canada	A2	101
1	Gold	Canada	A3	102
1	Gold	Canada		103
1	Gold	Canada		104
1	Gold	Canada		105
2	Diamond	Dubai	B1	201
2	Diamond	Dubai		202
3	Silver	Aus	C1	301
3	Silver	Aus	C2	302
3	Silver	Aus		303
3	Silver	Aus		304
4	platinum	Uk	D1	401
4	platinum	Uk		402
After loading data in QS Straight Table
Barcode(Keyfield)	Name	Country	Sold QR Code	Sold Id
1	Gold	Canada	A1	100
1	Gold	Canada	A2	101
1	Gold	Canada	A3	102
1	Gold	Canada	A1	103
1	Gold	Canada	A2	104
1	Gold	Canada	A3	105
2	Diamond	Dubai	B1	201
2	Diamond	Dubai	B1	202
3	Silver	Aus	C1	301
3	Silver	Aus	C2	302
3	Silver	Aus	C1	303
3	Silver	Aus	C2	304
4	platinum	Uk	D1	401
4	platinum	Uk	D1	402

[edwin]

1 million records for QLik Sense or QlikView is very small.  what you are experiencing is a data model problem, you may want to paste your DM 

[MS90]

Included script

 included script

[Or]

I'm not sure I follow here. Sold QR Code isn't the same field as Sold Ref in your first table. Additionally, your join appears to be based strictly on the Barcode field, and there are multiple rows with the same barcode, meaning if there is more than one QR code associated with each Barcode, you will inherently get duplication.

[MS90]

Sold ref in db is same column sold QR code in qs are same columns and key field is Bar code.

Sold Qrcode is not available for 103,104,105 values In  sold I'd db but values duplicating in qs

[Or]

Sold QR Code isn't linked to Sold Id, it's linked to Barcode...

[MS90]

Yes