Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everybody,
how to clean dirty values that make me duplicate the values of other fields?
thank you
What to do with duplicated values should be also a business decission to set the conditions on wath data has to be retrieved when there are duplicates.
As a simple fix you can add "Where not exists(Code)" before the semicolon that cleses the LOAD instruction:
LOAD ...
FROM ...
Where not exists(Code); // It will keep only the first row of each Code, other rows with the same Code are not loaded.
thank you for the answer but instead of queues what should I put
Hi, sorry for long delay but I don't undestand your question