Inserting Text When Row Found On Table 2

[pieface]

Hi,
I am producing a report and need an attribute to be defined so that if a row is found on that table it returns a value of 'Y' into the report.

Any ideas ??

 

[iolaper]

Well if it is not a big deal, you can redefine that particular column used for your attribute as a fact. Define a metric that has a max(<fact>) set at your report level(or the level you deem it fit).
Use thresholds now to replace the row for which you would like to replace a 'Y' instead.
This is usually the most straighforward and easy way!

 

[Z3]

If you really want an attribute, your attribute can be defined as ISNULL(col_name, 'Y', 'N') will return anything exist as 'Y' (check the syntax).
You can also create a metric on top of attribute ID similar to iolaper's post