Unique Values Pulling Through twice

user000253
user000253 Member
in Magic ETL

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?

Test.JPG


Tagged:

Best Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    Answer ✓

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

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • GrantSmith
    GrantSmith Coach
    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    Answer ✓

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

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • GrantSmith
    GrantSmith Coach
    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories