Duplication Problems

[Felipe02]

Hello everyone I'm having a problem with a certain field.

I noticed that in my database when adding this field "Centro de Custo" it duplicates the lines not distinguishing the values:

[Felipe02]

This is my data base, i try used the LOAD DISTINCT but dosen't work.

[RELATORIO]:

LOAD DISTINCT

    "Ordem de Compra",

    "Numero da SIC",

    "Processo",

    "Data abertura",

    "Situacao",

    "Tipo Compra",

    "Frete_SICWEB",

    "Frete_OC",

    "Frete_fornecedor",

    "Codigo_fornecedor",

    "Codigo_transportadora",

    "Codigo_centrodecusto",

    "Centro de Custo",

    "Tipo de Categoria",

    "Tipo SUB Categoria",

    "Numero do Projeto",

    "Descricao do Projeto",

    "% ICMS",

    "Frete",

    "Valor Total",

    "Tipo de Prazo",

    "Descricao",

    "Motivo",

    "Descricao Item",

    "UN Item",

    "Quantidade do Item",

    "Preco unitario do Item",

    "% IPI Item",

    "Valor Total Item",

    "Aprovador",

    "Nome do solicitante",

    "Comprador",

    "Nome Transportadora",

    "Prazo de entrega",

    "Data da OC",

    "Status da OC",

    "Parcela",

    "Prazo medio de pagamento",

    "Nome do Fornecedor",

    "CNPJ/CPF",

    "NFe",

    "Data Entrada"

FROM [lib://Qlik Files - Root/QVD/PO/RELATORIO_SIC.qvd] (qvd);

[avinashelite]

Think their might be unseen space or tab value which is not visible , try like trim("Centro de Custo") as "Centro de Custo"...this should solve , if not please help to share the sample data 

[Felipe02]

Did not work originally the code field of this field and the field itself has the original data like this in the spreadsheet:

In Qlik Sense it separates the "Centro de Custo" but duplicates the lines.

[avinashelite]

In the latest image , I was you are having few transformation in the scripts , could you help to share the complete script with transformation code ....

If I feel duplication is happening because of other filed or transformation , try like this just load only 2 fields the primary Key or unique field and the column which your saying duplicate without transformation and check whether its till the same , if its not duplicating then its from some other filed or transformation