how to do normalized when in core_company_list normalized is false

Litu05
Tera Contributor

how to do normalized when in core_company_list normalized is false

1 ACCEPTED SOLUTION

Amarjeet Pal
Kilo Sage
Kilo Sage

Hello @Litu05 ,

I would require more information from you to understand your need. But from understanding to do the normalization below configuration is important.
If the `normalized` field in the `core_company_list` table is set to false, it typically means that the data in that table has not been normalized or standardized. To normalize the data, you would need to identify any inconsistencies or duplications within the data and then restructure it into a standard format. This could involve updating values, merging duplicate records, and ensuring that all fields are consistently formatted. Once the data has been normalized, you can update the `normalized` field in the `core_company_list` table to true to reflect that the data has been standardized.

 

Thanks

Amarjeet Pal

View solution in original post

5 REPLIES 5

Amarjeet Pal
Kilo Sage
Kilo Sage

Hello @Litu05 ,

I would require more information from you to understand your need. But from understanding to do the normalization below configuration is important.
If the `normalized` field in the `core_company_list` table is set to false, it typically means that the data in that table has not been normalized or standardized. To normalize the data, you would need to identify any inconsistencies or duplications within the data and then restructure it into a standard format. This could involve updating values, merging duplicate records, and ensuring that all fields are consistently formatted. Once the data has been normalized, you can update the `normalized` field in the `core_company_list` table to true to reflect that the data has been standardized.

 

Thanks

Amarjeet Pal

 can you help me what is purpose of doing normalization & how it helps.

i did for one primary company there is one normalized company name i.e standardized company name & mapping it to many  companies. 

Sure @Litu05 , here's an example of how normalization could be used to manage company data in ServiceNow:

Suppose you have a table called `core_company` that contains information about companies, including their names, addresses, and contact information. When users create records in this table, they might enter the company name in various formats or spellings (e.g., "ABC Inc.", "ABC Incorporated", "ABC Corp", etc.), which can make it hard to search for or analyze data across multiple records.

To normalize this data, you could create a new table called `u_company_standardized` already table will be there OOTB , that includes a list of standardized company names. This table would have two fields: `u_name_original` and `u_name_standardized`. Whenever a user creates or updates a record in the `core_company` table, you could use a business rule or script to look up the corresponding standardized name from the `u_company_standardized` table based on the original company name entered by the user. If no match is found, you could create a new record in the `u_company_standardized` table with the original name as well as a normalized version of the name.

By doing this, you can ensure that all company names are stored consistently across your system, making it easier to search for and analyze data. Additionally, if any company names change in the future (e.g., due to mergers or acquisitions), you can update them once in the standardized table rather than having to update them across multiple records in different tables.

Hope your concept of normalized is clear now . Please mark helpful to all my replies and correct answer if you are happy.

Can you suggest how can I be conceptwise strong in sevicenow & how can I get a remote job with good pakage .in servicenow. as my age is now 45 last 2 yrs I am working with I was bit late as earlier  I was in Marketing just last 2 yrs sifted to servicenow devoper