Forum Discussion

kobkabnaja's avatar
kobkabnaja
Helper II
1 year ago

Cannot replace error with null

Hi community,   Apologies for what might seem like a basic question, but I am facing an issue converting text entries to null values in my dataset. While I’ve reviewed multiple examples online, I s...
Data Protection
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
1 year ago

While it's difficult to see the values in your picture, it appear that there is an error in the column to the left, which will persist. Why not split that column to the left by the ";" delimiter, choosing "Split to new rows" in the advanced options? Then you can convert to numbers without having to filter. 

 

--Nate

  • kobkabnaja's avatar
    kobkabnaja
    Helper II
    1 year ago

    Thanks, Anonymous , for the quick response!

    It turns out I got an error across the entire row. After looking into the details, I found that the highlighted column contains these problematic values.

    Would you recommend changing this entry, "72130620;72130617;72130618;72130619," to something else temporarily, and then converting it back to a whole number?

    Thanks!

    K

     

    • ronrsnfld's avatar
      ronrsnfld
      Super User
      1 year ago

      1. Which is the first Applied Step that shows that error?

      2. Can you create a data sample, as text which can be easily copy/pasted, that can be used to reproduce your problem. Change any confidential information to something random but that still has the same format and data type as your original.