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