This content has been marked as final. Show 6 replies
As per my understanding and the forum - you need display last name for the contact typ -= 'IA'
And, either you dont want to filter them in logical table source or write a case statement which shows nulls or 'N' and filter by 'N'.
And, you mentioned that you need it from back end.
So, Why dont you create another column in physical table (Database).
Say - I have table employee id, first name, last name, cont type
Now modify it by creating another extra column - display name
So, your table changes to employee id, first name, last name , cont type, display name
Now, based on your condition - update your display name column.
If, your unable to do that in database. Create a new physical table in physical layer - using select statement.
And, generate the table Emp Display -- which holds Employee id, Display name. And, display name gets generated by case statement.
this will definitely resolve your issue.