Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to already in the upload script remove duplicates, similar to how this works in excel: Data/Remove duplicates and that you can select a value based on which you would like to deduplicate
Try this
LOAD DISTINCT
Field1,
Field2,
Field3
FROM
.......
Thanks how should I define the value based on which it should deduplicate. In my case it is value “Trading Co”