🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

Data Prep remove a specific string

Janet_21505

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

Find more posts tagged with

English

Monarch

Accepted answers

All comments

Mo Abdolrahim

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

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
------------------------------
"