I don't want to show duplicates.

[Paknanarn23]

I don't want to display duplicate data, what should I do?

[Prem0212]

While loading itself you can use the distinct for the field(Primary key field) and load

[Paknanarn23]

I did but the data is still showing duplicate.

[Prem0212]

If u can give the proper requirement and scenario then solution can be figured out.

[BrunPierre]

@Paknanarn23 perhaps something like this.

TmpData:
LOAD  Hash128("KCE DATE", KCEPART, WorkOrderNo, "WorkOrderNo(Inner)", ProductionNo) as Hash, 
*
FROM SourceTable;

Data:
LOAD *
Where DuplicatesNo = 0;

LOAD Hash,
     Count(Hash)-1 as DuplicatesNo
Resident TmpData
Group By Hash;

Left Join(Data)
LOAD *
Resident TmpData;

DROP Fields Hash, DuplicatesNo From Data;
DROP Table TmpData;