Skip to main content

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

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

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.

Reply


Community Terms of Use & ConditionsCookie settings