Enricher SPLIT_PART() Function Not Working As Expected
D
David Cricchi
started a topic
over 2 years 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
over 2 years 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
over 2 years 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 Oldest FirstDavid 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 !
-
LOV label in Named Query
-
How we can set Dynamically changing Form field Description?
-
Is it possible to have a conditional survivorship rule based on a SemQL filter (akin to the filter on privileges)?
-
Where Do I View 2 Merged Records?
-
Show/hide an attribute in a form
-
Restrict access of attributes
-
Is it possible to manage visible/invisible value in List depend on user role??
-
Why am I unable to merge duplicates?
-
How are child records selected when parent records are manually merged?
-
Can the response from the API Call Response can be formatted differently in the JSON output?
See all 178 topics