Multiple IDs in different fact tables looks for name from one table

[#1]

Hi All,

I have 4 tables which has IDs and the name and relevant details for those IDs is from one table which is user table.

In maintable i have 4 different IDs but those IDs names,etc are from User table

Likewsie I have Task table with 2 IDS and the names,etc for those 2 IDs is from Users table

Likewise I have approval table looking for names,etc from Users table

MainTable:

LOAD * INLINE [

    F1, F2, F3, F4, F5

    MainID, AssigneeID, OwnerID, RequestorID, UpdatedbyID

    1, 31, 12, 11, 31

    2, 45, 12, 12, 45

    3, 26, 11, 8, 12

    4, 5, 12, 12, 8

    5, 22, 8, 11, 22

];

TaskTable:

LOAD * INLINE [

    F1, F2, F3

    TaskId, TaskRequestorID, TaskupdatorID

    1, 8, 22

    2, 22, 22

    3, 8, 8

];

ApprovalTable:

LOAD * INLINE [

    F1, F2, F3

    ApprovalID, ApprovalRequstorID, ApprovalUpdatorID

    11, 8, 11

    12, 11, 12

];

********************Users Table***********

UserDetail_Table:

LOAD * INLINE [

    F1, F2, F3, F4

    UserID, Name, email, Phone

    5, Antony, a@a.com, 1234

    8, Lucy, b@a.com, 2345

    11, Rose, c@a.com, 3456

    12, Wilson, d@a.com, 4567

    22, Max, e@a.com, 5678

    26, Richard, f@a.com, 6789

    31, Raj, g@a.com, 1122

    45, Alex, h@a.com, 2233

];

Like this i have 2 more tables which needs detail from users table..the method i tried is loading the users table equal to the number of times the ID is present. In that it avoids sync keys however the problem is loading same table almost 8 times. Applymap dint work for this either. can anyone help.

I have also attached the test doc

Thanks in advance

[ashfaq_haseeb · Accepted solution]

Hi,

May be like this.

have a look at attached document

Regards

ASHFAQ

[ashfaq_haseeb]

HI,

have a look at below post

http://community.qlik.com/message/635651#635651

Regards

ASHFAQ

[#4]

Thank you Ashfaq ...Thanks a lot 🙂