topic Re: Null Value Problem in Brasil

Null Value Problem

VishalWaghole — Fri, 23 Nov 2012 09:53:26 GMT

Hi guys,

Recentaly i worked on oracle apps database.

In that One table having column name like Authorization_status,

and that column contains values like :- approved, rejected, in process, incomplete with some null values.

Oracle Standard Report convert that Null Values into incomplete state,

But If we want convert this with QlilView Dashbord,

then how its possible...

Thanks

Vishal.

erichshiino — Fri, 23 Nov 2012 16:14:04 GMT

Hi, Vishal.

You can handle it in script.

if your extraction script is like this:

Select ID,App, Authorization_Status from App_Table;

You can check if the Authorization_status is null:

Load ID, App, if( isnull(Authorization_Status), 'incomplete', Authorization_Status) as Authorization_Status ;

Select ID,App, Authorization_Status from App_Table;

Hope it helps,

Erich

VishalWaghole — Sat, 24 Nov 2012 06:22:09 GMT

Hi Erich,

Its Working, Thanks..............