Skip to main content
Solved

Identify Company/Organization Name

  • September 16, 2024
  • 2 replies
  • 50 views
F
Universe Traveller

Hi All,

From source I am getting only one column as FullName and there is no other column which can identify whether the Fullname is personā€™s name or a companyā€™s name. In Ataccam, is there any out of box functionality built which can parse the FullName column and identify the party type?

If yes, then kindly do letĀ me know the steps which I need to perform to achieve this.

Thanks

FS

Best answer by Phil Holbrook

Hi @fshahinĀ - thatā€™s a tricky one, especially if you consider that many companies have ā€œpeopleā€ names - John Lewis, say,Ā 

Strip titles is a good approach - for a more comprehensive sample, try looking at the supplied Cleanse Company Name components - there are a few: you can find them under theĀ respective country-specific step selectionĀ in ONE Desktop - you will probably need to open/createĀ a blank plan file before this list shows all the right steps.

So for instance the GB component is here:

Drag this component into a blank plan and ONE Desktop will unpackĀ the source file for the component into the folder your COMPONENTS shortcut points to.Ā  I picked this up from vn 14.5.2 but I think itā€™s in all recent versions.

Note that this component uses a partial snapshot copy of the list of registered UK companies available from Companies House, and a rather elderly one at that. It is not automatically going to work or be kept up to date without ongoing work as part of your solution design.Ā  Using a full copy may be slow: there are a lot more registered companies than the supplied lookup holds.

It does other things than just that lookup though, so it may give you some ideas.

2 replies

F
Universe Traveller
  • fshahinUniverse Traveller
  • Author
  • Universe Traveller
  • September 18, 2024

Hi All,

I have used Strip Tiles transformation to find the string in Full Name and based on that identifying whether its Organization or Person.Ā 

Let me know if we have any other solution for it.

Thanks

FS

Phil Holbrook
Ataccamer
Forum|alt.badge.img+1
  • Phil HolbrookAtaccamer
  • Ataccamer
  • Answer
  • September 20, 2024

Hi @fshahinĀ - thatā€™s a tricky one, especially if you consider that many companies have ā€œpeopleā€ names - John Lewis, say,Ā 

Strip titles is a good approach - for a more comprehensive sample, try looking at the supplied Cleanse Company Name components - there are a few: you can find them under theĀ respective country-specific step selectionĀ in ONE Desktop - you will probably need to open/createĀ a blank plan file before this list shows all the right steps.

So for instance the GB component is here:

Drag this component into a blank plan and ONE Desktop will unpackĀ the source file for the component into the folder your COMPONENTS shortcut points to.Ā  I picked this up from vn 14.5.2 but I think itā€™s in all recent versions.

Note that this component uses a partial snapshot copy of the list of registered UK companies available from Companies House, and a rather elderly one at that. It is not automatically going to work or be kept up to date without ongoing work as part of your solution design.Ā  Using a full copy may be slow: there are a lot more registered companies than the supplied lookup holds.

It does other things than just that lookup though, so it may give you some ideas.

A
Community Terms of Use & ConditionsCookie settingsAccessibility statement