Schema "Template"

I suggest you look at the video series on YouTube that explains scripting in Identity Manager in general and the value templates in particular (starting at #16). https://youtube.com/playlist?list=PL242czeZwlAk0T2AcqpSFtBOXQfkP9f5J&feature=shared

The documentation helps as well. It explains the templates for generating values https://support.oneidentity.com/technical-documents/identity-manager/9.2.1/configuration-guide/11#TOPIC-2203978 or the $-notation https://support.oneidentity.com/technical-documents/identity-manager/9.2.1/configuration-guide/72#TOPIC-2204268

Thank you for that, I was able to add that to my script, and enabled the overwrites but it seems it still not showing on the existing system role, do I need to trigger something like on the synchronization? I tried to close the tool and open it but it still not showing. Thank you

Please check the following threads  Recalculate Templates  or Update All account after I change a template 

Another option is to use the consistency check Templates (in the Content section) on the table where you updated the templates. Please check the documentation https://support.oneidentity.com/technical-documents/identity-manager/9.2.1/operational-guide/21#TOPIC-2204499

Thank you, Markus, additional question is what best approach can I use when using a "Like" for example is all column that has "Test_XXX" the XXX are the placeholder I used If $columnname$ like "Test%" it seems the % wildcard is not working, any better approach? Thank you so much.

You cannot use a wildcard operator, but you can provide a list of pipe separated column like TestA|TestB|TestC

Can I use Regex for that I mean it's not complicated to use? 

I'm a little bit confused. Can you specify where exactly do you want to use Regex? My answer assumed you meant the Column parameter of the ExecuteTemplates process step.

I'm a little bit confused. Can you specify where exactly do you want to use Regex? My answer assumed you meant the Column parameter of the ExecuteTemplates process step.