Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hi Erich,
Its Working, Thanks..............