Enricher SPLIT_PART() Function Not Working As Expected
D
David Cricchi
started a topic
7 months ago
Hello,
I was advised in this forum to use the SPLIT_PART(SourceFirstName) function to split strings delimited by
I have the following Enrichers with attributes created to capture different sections of the name:
However, when I submit data with multiple names delimited by spaces and hyphens, these values are not being split in the MD table, and thus not matching with the SemQL Matchers I have in place. Here is an example of how the data is being populated in the FirstNamePart attributes:
I need help understanding why these names with spaces and hyphens are not getting separated into NamePart2 and NamePart3 attributes. (This is fake data created for test purposes)
Thanks!
Best Answer
M
Matthieu DE PILLOT DE COLIGNY
said
6 months ago
Hello,
It looks like your enricher splits the names on ‘- ‘ and not
on ‘-‘ or ‘ ‘ only, that’d why your attributes aren’t split. The SPLIT_PART
function only accept one delimiter, if you want to split on multiple
delimiters, a good workaround is to use a regex first that will convert all the
delimiters into a specific one, and then SPLIT_PART on that delimiter. Here is a stackoverflow dealing about that topic.
I think the data transformation is not happening somewhere in the enricher or stepper portion of the Semarchy process.
If anyone has ideas on how to correctly configure my entity to apply these data transformations it would be greatly appreciated. Thanks!
M
Matthieu DE PILLOT DE COLIGNY
said
6 months ago
Answer
Hello,
It looks like your enricher splits the names on ‘- ‘ and not
on ‘-‘ or ‘ ‘ only, that’d why your attributes aren’t split. The SPLIT_PART
function only accept one delimiter, if you want to split on multiple
delimiters, a good workaround is to use a regex first that will convert all the
delimiters into a specific one, and then SPLIT_PART on that delimiter. Here is a stackoverflow dealing about that topic.
David Cricchi
Hello,
I was advised in this forum to use the SPLIT_PART(SourceFirstName) function to split strings delimited by
I have the following Enrichers with attributes created to capture different sections of the name:
However, when I submit data with multiple names delimited by spaces and hyphens, these values are not being split in the MD table, and thus not matching with the SemQL Matchers I have in place. Here is an example of how the data is being populated in the FirstNamePart attributes:
I need help understanding why these names with spaces and hyphens are not getting separated into NamePart2 and NamePart3 attributes. (This is fake data created for test purposes)
Thanks!
Hello,
It looks like your enricher splits the names on ‘- ‘ and not on ‘-‘ or ‘ ‘ only, that’d why your attributes aren’t split. The SPLIT_PART function only accept one delimiter, if you want to split on multiple delimiters, a good workaround is to use a regex first that will convert all the delimiters into a specific one, and then SPLIT_PART on that delimiter. Here is a stackoverflow dealing about that topic.
Does this also answer this other forum ?
Have a great day !
- Oldest First
- Popular
- Newest First
Sorted by PopularDavid Cricchi
I think the data transformation is not happening somewhere in the enricher or stepper portion of the Semarchy process.
If anyone has ideas on how to correctly configure my entity to apply these data transformations it would be greatly appreciated. Thanks!
Matthieu DE PILLOT DE COLIGNY
Hello,
It looks like your enricher splits the names on ‘- ‘ and not on ‘-‘ or ‘ ‘ only, that’d why your attributes aren’t split. The SPLIT_PART function only accept one delimiter, if you want to split on multiple delimiters, a good workaround is to use a regex first that will convert all the delimiters into a specific one, and then SPLIT_PART on that delimiter. Here is a stackoverflow dealing about that topic.
Does this also answer this other forum ?
Have a great day !
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 274 topics