Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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...
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...
Fantastic, thank you very much Rathodniky.
Have a great weekend!