I have two tables
1. Main Table
2. small Table
Let us Consider, I have a state field in two tables and description of the state in only Small Table.
Now To display the state and associated description, I have Joined these two tables and defined the object at universe level by concatenating these two fields, it works fine and Now I have got a typical requirement which is ,
In my main table for few selected state Id's the concatenation is done at DB level and the data available for this state id is a direct concatenated value, and I am doing the concatenation in universe level for all state Id's. So as A result the concatenation will happen twice, NOW i AM BIT CONFUSED OF HOW TO AVOID THIS SCENARIO.