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

  • mabdolrahim_1357
    mabdolrahim_1357
    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