Mapping fields from different tables

Fri, 03 Aug 2012 05:44:46 GMT

Hi all,

I am very very new to qlikview and I am using the personal edition.

I have 3 tables which came from 3 different worksheets of an excel file.

The code I have are as per below:


LOAD PSC, 
     FUNCTION_DOMAIN, 
     TASK_CONTROL_ID, 
     PROCESS_REFNUM, 
     MI_INVENTORY_ID, 
     REPORT_NAME, 
     TASK_ID, 
     TASK_NAME, 
     TASK_PROCESSOR, 
     TASK_START_DATE, 
     TASK_END_DATE, 
     TASK_DURATION, 
     TASK_RAG, 
     TASK_STATUS, 
     TASK_ACTION_STAT, 
     PROC_ID, 
     ACTUAL_TASK_START_DATE, 
     CYCLE_TIME, 
     Calendar_Date
FROM

(ooxml, embedded labels, table is SWF_DATA_CONTROL_REPORT);
LOAD TRAN_ADHC_ID, 
     [Entity ID], 
     [Process ID], 
     [Process Name], 
     [Adhoc Category ID], 
     [Category Name], 
     PSC_FUNCTION1, 
     Processor, 
     [Start Date/Time], 
     [End Date/Time], 
     [Elapsed Time], 
     [Manual Start Date/Time], 
     [Manual End Date/Time], 
     [Calendar Date], 
     NEW_CALENDAR_DATE, 
     ORIG_CYCLE_TIME, 
     ADJUSTED_CYCLE_TIME, 
     NEW_START_DATE_TIME, 
     New_END_DATE_TIME
FROM

(ooxml, embedded labels, table is TT_DATA_CONTROL_REPORT);
LOAD [email ID], 
     [First Name], 
     [Last Name], 
     Team, 
     Location, 
     [Manager/TL], 
     [Supervisor/POC], 
     [Workstream Head], 
     [Coverage Head], 
     Att_01, 
     Att_02, 
     Att_03, 
     Start_User_Date, 
     End_User_Date, 
     Location_ID
FROM

(ooxml, embedded labels, table is USER_LIST);

The fields TASK_PROCESSOR (from the field table) and Processor (from the 2nd table) are referring to the email addresses of the staff.

The 3rd table has the master list of email addresses [email ID] and the corresponding team Team .

Basically all I want to do is to "map " the fields TASK_PROCESSOR, Processor and [email ID] so that if I select the TEAM from a listbox the rest of the data from the other tables will follow.

Thanks in advance.

Re: Mapping fields from different tables

Anonymous — Fri, 03 Aug 2012 07:10:57 GMT

LOAD  TASK_PROCESSOR as Staff_EmailID, 
FROM
(ooxml, embedded labels, table is SWF_DATA_CONTROL_REPORT);
LOAD Processor as Staff_EmailID, 
FROM
(ooxml, embedded labels, table is TT_DATA_CONTROL_REPORT);
LOAD [email ID] as Staff_EmailID, 
FROM
(ooxml, embedded labels, table is USER_LIST);

Try this.. Creating Alias would make a physical join from the three different tables.

You can check the join after your load with Ctrl+T

Hope it helps...

Re: Mapping fields from different tables

Fri, 03 Aug 2012 07:34:30 GMT

Fantastic, thank you very much Rathodniky.

Have a great weekend!

topic Mapping fields from different tables in QlikView

Mapping fields from different tables

Re: Mapping fields from different tables

Re: Mapping fields from different tables