Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
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.
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