topic Re: data quality, clean puntuaction, spacing in App Development

data quality, clean puntuaction, spacing

Billy_u — Sat, 16 Nov 2024 05:34:43 GMT

hi everybody,

how to clean dirty values that make me duplicate the values of other fields?

thank you

Re: data quality, clean puntuaction, spacing

rubenmarin — Mon, 17 Jun 2019 09:51:05 GMT

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.

Re: data quality, clean puntuaction, spacing

Billy_u — Tue, 18 Jun 2019 07:42:34 GMT

thank you for the answer but instead of queues what should I put

Re: data quality, clean puntuaction, spacing

rubenmarin — Wed, 26 Jun 2019 18:33:36 GMT

Hi, sorry for long delay but I don't undestand your question