0 Replies Latest reply: Oct 16, 2014 7:01 AM by Vincent Epiphania RSS

    Multiple IDs in different fact tables looks for name from one table,can anyone help

      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