To elaborate, we have dataset as below:
“Pay String” is the complete string
Col1, Col2, Col3, Col4 has the comma separated values from column “Pay String”
|Pay string| |COL1| |COL2| |COL3| |COL4|
Bill,Vod,ISH,123 Bill Vod ISH 123
Data dump which is used for identifying accounts.
“Bank String” has the complete string
Bank_col1, Bank_col2, Bank_col3, Bank_col4 has the comma separated values from “Bank String” column.
|Bank string| |Bank_col1| |Bank_col2| |Bank_col3| |Bank_col4|
Bill,Vod,EMA,1234 Bill Vod EMA 1234
We want to know how to search for the “COL1” string with the entire “Bank string” with unique matches. Similarly for 'COL2','COL3','COL4'
By using Join node we are getting two matching records for eg. value=Bill in above dataset
X-ref node gives two matches.
Lookup gives First match.
We want those records that have unique matches and ignore those having two or more matches.
Please sign in to leave a comment.