How do you change blank values to null values

Jeremiah_22341
Jeremiah_22341 New Altair Community Member
edited September 2022 in Community Q&A
Tagged:

Answers

  • Zhanna Abidor_20687
    Zhanna Abidor_20687
    Altair Employee
    edited September 2022

    Hello Jeremiah, 

    Are you using DataPrep studio or Monarch Classic ? 

    In DataPrep studio: 

    if your column type is text based you can right click on the column and choose Replace function and choose Null option which will allow to convert to any text you want including 'NULL'. If it is a number column same operation will convert blank column to 0.00

    You also can create a new calculated field based on that column that has null/blank values and convert it to zeros. 

     

    image

  • CPorthouse
    CPorthouse
    Altair Employee
    edited September 2022

    If it is a text field, you can create a new formula column with the following formula:

    if(isblank([blank_column]),str(1/0),'')

    where [blank_column] is the field you are testing for a blank value.

     

Categories