Skip to Content
Former Member
Apr 02, 2014 at 05:30 AM

How to Make A Conditional Filter


Hi All,,

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.