Data Prep remove a specific string

Janet_21505
Janet_21505 Altair Community Member
edited April 2020 in Community Q&A
​What is the best approach to solve the removal of "No Data Available" string in a column?  For instance the column could be listing name, but instead of a blank or null there is a string "No Data Available"

------------------------------
Janet Grimsley
VP, Business Intelligence
The Fauquier Bank
Warrenton VA
(540) 349-0215
------------------------------
Tagged:

Answers

  • Mahmoud
    Mahmoud
    Altair Employee
    edited April 2020
    Hi Janet,
    you can create formula field and use the IF function.  Assume the column name is Name you can use the following formula:

    IF(Name="No Data Available","",Name)
    The above will create a new field.
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 04-13-2020 05:17 PM
    From: Janet Grimsley
    Subject: Data Prep remove a specific string

    What is the best approach to solve the removal of "No Data Available" string in a column?  For instance the column could be listing name, but instead of a blank or null there is a string "No Data Available"

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    (540) 349-0215
    ------------------------------
    "
  • Steve_Caiels
    Steve_Caiels
    Altair Employee
    edited April 2020
    Hi Janet,

    In Data Prep Studio, you can right click on the column and use the 'Replace->Using Find and Replace' option. This will act on the original column or you can select the 'create new column' option, if you prefer.

    Regards,
    Steve.

    ------------------------------
    Steve Caiels
    Professional Services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 04-13-2020 05:17 PM
    From: Janet Grimsley
    Subject: Data Prep remove a specific string

    What is the best approach to solve the removal of "No Data Available" string in a column?  For instance the column could be listing name, but instead of a blank or null there is a string "No Data Available"

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    (540) 349-0215
    ------------------------------
    "

Categories