Blocking condition in tMatchGroup for a column with multiple values

[Prashant_Patil]

Hi,

I am using a tMatchGroup component where I need to use a blocking condition as first character of Last_Name column. But, as I am getting multiple words in Last_Name, i need to have each words first character in the blocking condition.

For eg. Last_Name column contains "Lloyd George"

I want to use Last_Name in blocking condition of tMatchGroup blocking condition, in such a way that the records coming in tMatchGroup, if have Last_Name starting with L or G should pass the blocking condition and go for further rules check.

So, how can i handle this situation. Request you to please help here ASAP.

I have been searching the way to do this since many days, but didnt get any breakthrough.

[Anonymous]

Hello,

Could you please elaborate your case with an example with input and expected output values?

Screenshots will be preferred.

Best regards

Sabrina

[Prashant_Patil]

Hi,

Please find below the example:

Input:

Output:

 

i am passing input to tMatchGroup having t-Swoosh algorithm. I need the blocking condition of zip and (lastName1 / lastName2) so that it gives me records based on first character of both words in last name. Also, i have a rule for firstName.

 I hope this makes it more clear. Please do let me know if anything else is required.