Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Tracking-Table:
Opco | Priority | Startdate | Enddate | ALM/SLA | task Type |
ComEd | High | 1/26/2017 | 2/2/2017 | IM001383440 | Support |
ComEd | Medium | 1/26/2017 | 2/14/2017 | IM001383795 | Support |
ComEd | High | 2/3/2017 | 2/10/2017 | IM001382648 | Support |
ComEd | High | 1/26/2017 | 2/16/2017 | ALM# 2720 | Maintanence |
PECO | Low | 2/8/2017 | 2/15/2017 | ALM# 2765 | Support |
Timesheet-Table:
Date | time type | Resource | Hours | company | work area detail |
2/7/2017 | Actual | Shakila Desamuthu | 5 | PECO | Exelon Utilities - Qlik- ETL Job Analysis |
2/6/2017 | Actual | Ranjit | 3 | PECO | Exelon Utilities - Qlik- OWM Resolved Export |
2/6/2017 | Actual | Ranjit | 5 | ComEd | Exelon Utilities - Qlik- ETL Job Analysis |
2/3/2017 | Actual | Durga | 5 | ComEd | Exelon Utilities - Qlik- OWM Resolved Export |
2/1/2017 | Actual | Sriram S | 5 | PECO | Presentation |
I want to map these two tables based on work area detail becuase here i want select any resource means it will show based priority level.here creating priority level based task Enddate only. But the problem here is i don't have any same field. I cannot modify Timesheet-Table. can make changes the Tracking-table. Can anyone suggest how to mapping the both table.
What is the desired output from the sample provided above?
Sunny,
Date | Resource | Hours | company | work area detail | worktype | Priority | ALM/SLA | Enddate |
2/7/2017 | Shakila Desamuthu | 5 | PECO | Exelon Utilities - Qlik- ETL Job Analysis | support | High | IM001383440 | #VALUE! |
2/6/2017 | Ranjit | 3 | PECO | Exelon Utilities - Qlik- OWM Resolved Export | support | Medium | IM001383795 | 2/14/2017 |
2/6/2017 | Ranjit | 5 | ComEd | Exelon Utilities - Qlik- ETL Job Analysis | support | High | IM001382648 | #VALUE! |
2/3/2017 | Durga | 5 | ComEd | Exelon Utilities - Qlik- OWM Resolved Export | support | High | ALM# 2720 | 2/16/2017 |
2/1/2017 | Sriram S | 5 | PECO | Presentation | Enhancement | Low | ALM# 2765 | #VALUE! |
This is the desired output.
suppose i want to select a particular resource means it will show based on work area deail and priority leve. we will show In that particular ALM/SLA ticket task will crossed enddate or not.
So Date is not related to Start date and end date in any way? I am having a hard time understanding how Row 1 from your output links to row 1 from each of the tables? Or is it a straight rownumber match?
Row Num1 from Table1 Joins with Row Num1 from Table2
Row Num2 from Table1 Joins with Row Num2 from Table2
Row Num3 from Table1 Joins with Row Num3 from Table2
Row Num4 from Table1 Joins with Row Num4 from Table2
Row Num5 from Table1 Joins with Row Num5 from Table2
sunny,
Tracking table is task basics.
Timesheet table is daily work basics related to task.
Sunny,
Till now both these tables are not mapped in anyway. so can you give me a suggestion of how can be mapped it.
Unless I know how you came up with the desired output, I am going to give this to you:
Table:
LOAD RowNo() as JoinField,
Priority,
....
FROM Tracking-Table;
Join (Table)
LOAD RowNo () as JoinField,
Date,
time type,
.....
FROM Timesheet-Table;
sunny,
i have used this method it is not correctly mapped. Is there any possibility for adding any column in tracking table based on time sheet table. i have posted the desired output screen is my expected only not a perfect one. if you know any other possibility to tracking with task based on priority means suggest.
Or otherwise u know any data repairing method in tracking table. Is possible?