Naming in a field

SilviyaK — Mon, 20 Feb 2023 12:44:21 GMT

Hi all,

Can anyone suggest to me an approach for the below situation:

I get data from multiple sources and therefore I get the field Company Name from all these sources. It turned out that in many of the sources this field is a manual input, so I have many different company names that actually refer to the same name, for example I can have:

Company Name Limited
Cpn - Name LTD
Company Limited
Company Name: Limited

Moreover, some of them are even more random, such as:

Sample Name International Limited
Sample Name INL
Sample Name - INL
Sample Name - INL.

Is there any function that I can use to somehow take out the main name of all these, so that I can have only one name for a company instead of multiple?

Thanks!

Re: Naming in a field

hic — Mon, 20 Feb 2023 12:53:51 GMT

Take a look at https://community.qlik.com/t5/Design/Data-Cleansing/ba-p/1464362

Re: Naming in a field

SilviyaK — Mon, 20 Feb 2023 14:16:30 GMT

Hi,

Thank you for this! I was thinking about a similar approach, but I was wondering if there is anything else.

Your article will definitely help!

topic Naming in a field in App Development

Naming in a field

Re: Naming in a field

Re: Naming in a field