Join and Nulls

[greend21]

I have two tables that automatically join on ID (Table Viewer shows two tables), where not all ID's in Table 1 are in Table 2. I thought when when I put this information in a table that the '-' was representing a null but if do IsNull(Indicator) I only get a result where the indicator exists. If the indicator represents condition X, how can I show the opposite as condition Y?

For example, I tried If( Indicator = 1, 'X', 'Y') but nothing is returned for fields where the Indicator is '-'.

TABLE 1
ID	Client
1	A
2	B
3	C
4	D

TABLE 2
ID	Indicator
1	1
2	1

Result
ID	Client	Indicator
1	A	1
2	B	1
3	C	-
4	D	-

[vishsaggi · Accepted solution]

Try this:

= Aggr(IF(ISNULL(NoteInd)=-1, 'Y', 'X'), ID, ID [Status])

[greend21]

Works perfectly! Thank you!

[Anil_Babu_Samineni]

If you are expecting in Front end, Try this way?

If(Match(Indicator,1),'X','Y')