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!
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 !
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!