I am trying to create table that shows any data that need to 'clean'. Data cleaning in short. Say example this particular bus travel to a bus_terminal_code call RUEWW. All my bus_terminal_code will link to bus_region_code. As this RUEWW is not a recgonize code, therefore the bus_region_code show a '-' as the output. I am trying to display a table where it will show all the '-' as output. Thus, user will know which data that needs to touch up.
I tried ways such as if(bus_region_code = '-' or bus_region_code = null(), 'SHOW')) but it does not work, any gurus can help
Null Value is not selectable, and cannot be used also on any Set Analysis as you suggest. You need to modafy your load script in order to "mark" those wrong values with an especial value (you can call it ERROR for example).
Then you'll be able to get all the ERROR related rows.
