Values are repeating in one column in Straight Table - 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 ande

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

[Or]

I'm not clear on what exactly you're asking...

Pagination is available in the new Straight Table object in Qlik Sense Cloud or May 2023, but a table with a million rows seems like a fairly pointless endeavor - nobody's going to page through all of that.

[MS90]

While adding dimensions in table  Sold Qrcode (Sold ref in database table)column is repeating. shown example above with two separate tables

For examples in database for key field value 1 having sold Ref three  values but while loading data in QS it is duplicating it is showing six values instead of three values 

Here Sold Qrcode(sold Ref in dbtable) and sold I'd are separate columns

We are using Feb 2023 version 

[Or]

Your example isn't showing any duplication. Every row appears to be distinct. If the rows aren't what you expect, I'd suggest checking that your schema is correct, but this isn't something that can be generically helped with, so you'd need to include the code along with sample data if you want someone to try and figure out what's wrong.

[MS90]

Included script