Account Correlation Using Template Based Approach - Not working

[jsatish]

Hi Team,

I am trying to implement the Account Correlation using the Template based with the below condition. But it is not working. 

Account Name 1: 12345
Account Name 2: 12345-1
Account Name 3: 12345-2

All the above three should be mapped with the user "12345"

Correlation Rule Template: TEMPLATE###users.username=(accounts.name.contains('-'))?accounts.name.tokenize('-')[0]:accounts.name

Correlation Rule SQL: (users.username)=(accounts.name) OR concat(users.username,'-1')=(accounts.name) OR concat(users.username,'-2')=(accounts.name)

Both correaltion rules are not mapping the accounts with user.

Any leads will be appreciated.

Regards,
SJ

[rushikeshvartak]

Try below 

(users.username)=(accounts.name)#concat(users.username,'-1')=(accounts.name)#concat(users.username,'-2')=(accounts.name)