1 of 1 people found this helpful
You've to transpose your Oracle table columns into rows. Find my appraoch
Option 1: At database level create a system view to transpose
CREATE OR REPLACE FORCE VIEW VIEW_NAME
SELECT 'DIVISION' AS SOURCE, DIVISION AS FUNCTION_CODE FROM TABLE
SELECT 'DEPARTMENT', DEPARTMENT FROM TABLE
SELECT 'SUBDEPARTMENT', SUBDEPARTMENT FROM TABLE
If your query on the above view then you'll get a result set like this
Now connect this view (VIEW_NAME) in tableau and blend with your excel source with FUNCTION_CODE common column.
Option 2: You can use custom SQL union in tableau If you don't want to create any view at database level.
First connect your oracle table in tableau. Use custom sql and write below mentioned query.
select 'DIVISION' AS SOURCE,DIVISION AS FUNCTION_CODE FROM TEMP_TABLE
select 'DEPARTMENT' ,DEPARTMENT FROM TEMP_TABLE
select 'SUBDEPARTMENT',SUBDEPARTMENT FROM TEMP_TABLE
Then add your excel source and blend with FUNCTION_CODE.
After blending you can get this
Let me know If this help.
If my solution helped you then kindly close the thread by marking my answer as correct. So that it may help others who've similar query.