I have successfully created a cross table of 'final sites' but I also need to include data where the field is null (although I have replaced with text in resident table) as well as 'y' (I only want to exclude where the field = 'n')
In the resident Main_Table where the field is null I have added text values that say 'not entered'
yes its in the first bit above.... my crosstable is pulling through data where the field = 'y' but I also need to bring through null values (where data has not yet been entered) In my resident table I have used isnull function to populate the fields as 'not entered'
I want a flag where field = 'y' or 'not entered'
just not sure how to combine with above script extract?
my crosstable is pulling through data where the field = 'y'
Where does it do that? I don't see a where clause doing that in the crosstable load.
In my resident table I have used isnull function to populate the fields as 'not entered'
Which I also don't see in the script you posted. But if you did then you've already solved your problem, haven't you?
I'm sorry, but I just don't understand what you're doing, what you're trying to do, what's not working, what the source data is and what the result data should be. Perhaps these documents can help you: