Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Mapping fields from different tables

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.

1 Solution

Accepted Solutions
rathodniky
Contributor

Re: Mapping fields from different tables

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...

2 Replies
rathodniky
Contributor

Re: Mapping fields from different tables

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...

Not applicable

Re: Mapping fields from different tables

Fantastic, thank you very much Rathodniky.

Have a great weekend!

Community Browser