Unique Values Pulling Through twice

I've used an excel upload method and I'm tidying up the dataset using Magic ETL. On one of my columns there is a value labelled "Test". For some reason it is pulling through as two unique values when it should only be one. I have tried to use 'replace text' but whatever I replace it with it pulls through again as two unique values. I thought there could be hidden spaces in the text but I don't know how to check or remove. Any advice?


Best Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟣
    Accepted Answer

    you can use a TRIM function in ETL or analyzer beast modes.

  • GrantSmith
    GrantSmith Indiana 🟣
    Accepted Answer

    Hi @user000253

    In the ETL you can use a String Operations tile with the Trim Spaces operation to remove any leading or trailing spaces.

Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!