topic Removing Noise wordss in QlikView

Removing Noise wordss

Thu, 30 Apr 2009 14:32:23 GMT

Hello,

I have a field in a table that has names of people/company. This field will also have noise words like 'Not Applicable', 'Unknown'....

There is a complete list of such noise words. Is there way I can remove all these noise words from the field.

Thanks in advance

Removing Noise wordss

Thu, 30 Apr 2009 15:48:30 GMT

Have you tried using replace?

Replace(NameField,'NoiseWord','')

/Martin

Removing Noise wordss

Anonymous — Thu, 30 Apr 2009 15:59:38 GMT

If I understand correctly you have a list of proper names with words like 'Not applicable' mixed in. You also have a list of these words.

If you want to replace the values with something else I would suggest reading up on Mapping Loads.

If you wish to simply remove the values that contain 'Not Applicable' and other similar things I would first load the list of Noise words and then load the Name field itself and in that load statement use a Where Not Exists condition to only load those rows where the name does not occur on the noise list.

Removing Noise wordss

Thu, 30 Apr 2009 16:06:09 GMT

Hi Manju,

You can able to achieve this by using exists() function.

There are different ways of using exists() function.

Attached application will help you solve your problem.

Regards

Sridhar

Removing Noise wordss

Thu, 30 Apr 2009 17:32:59 GMT

Thanks you all

Removing Noise wordss

rwunderlich — Fri, 01 May 2009 07:24:44 GMT

I think this may be easiest to do with MapSubstring().

NoiseMap:
MAPPING LOAD *, null()
;
LOAD * INLINE [
x
Terminated
Unknown
Not Applicable
where's waldo?
]
;
Names:
LOAD MapSubString('NoiseMap', Name) as Name
;
LOAD * INLINE [
Name
Company A Inc
Company B Terminated
Paul Not Applicable Smith
where's waldo? Jack Unknown Jones
]
;

-Rob