I am using Toad Visual query builder to build .TSM filed for our users. I am unable to find any custom grouping functions/mechanism available for this. Please go through the below example
Suppose i have a column (say EMP_ID) with the distinct values (1,2,3,4,5), i need a to have a new column(EMP_NICK_NAME) which checks the EMP_ID and show a string like below
1 --> ADAM
2 --> BEN
( consider , I do not have a reference table which has both the ID and the respective NICK_NAME and the user need to change this grouping on demand )
Its similar to a case/if statement in SQL, but i need this to functionality in the visual query builder, i have tried all the calculated column functions available and couldn’t recreate it.
If any one know how to do this , Please help me out .