The DQ rule is
Forename + Surname in POL Source System 1 must equal Full Name in AD Source System 2
I need to combine the two fields in Source System 1 first with a space between the name and then compare it to the filed in source system 2 which is the full name?
How can I go about this using the tools in infogix
Or Is regex better?
Thank you in advance
screen shots for rule.docx
Reviewing the attached document and requirements, it may be worthwhile to explore a simple concatenate of the data store node as a derived field ( as opposed to a join ). For example :
Looking at the LHS, the concatenate field is derived ( this is created manually, not pulled from the data ) :
Looking at the RHS :
Once this is in place, a recon node ( labeled "recon check" within photo ) will check both the LHS and RHS :
When building the derived field, you would do so by including the following formula ( space is included within the output this way ) :