Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to map the both table without any same column and field

Tracking-Table:

     

Opco

Priority

Startdate

Enddate

ALM/SLA

task Type

ComEdHigh1/26/20172/2/2017IM001383440Support
ComEdMedium1/26/20172/14/2017IM001383795Support
ComEdHigh2/3/20172/10/2017IM001382648Support
ComEdHigh1/26/20172/16/2017ALM# 2720Maintanence
PECOLow2/8/20172/15/2017ALM# 2765Support

Timesheet-Table:   

Date

time type

Resource

Hours

company

work area detail

2/7/2017ActualShakila Desamuthu5PECOExelon Utilities - Qlik-  ETL Job Analysis
2/6/2017ActualRanjit3PECOExelon Utilities - Qlik-  OWM Resolved Export
2/6/2017ActualRanjit5ComEdExelon Utilities - Qlik-  ETL Job Analysis
2/3/2017ActualDurga5ComEdExelon Utilities - Qlik-  OWM Resolved Export
2/1/2017ActualSriram S5PECOPresentation

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.

8 Replies
sunny_talwar

What is the desired output from the sample provided above?

Anonymous
Not applicable
Author

Sunny,
         

DateResourceHourscompanywork area detailworktypePriorityALM/SLAEnddate
2/7/2017Shakila Desamuthu5PECOExelon Utilities - Qlik-  ETL Job AnalysissupportHighIM001383440#VALUE!
2/6/2017Ranjit3PECOExelon Utilities - Qlik-  OWM Resolved ExportsupportMediumIM0013837952/14/2017
2/6/2017Ranjit5ComEdExelon Utilities - Qlik-  ETL Job AnalysissupportHighIM001382648#VALUE!
2/3/2017Durga5ComEdExelon Utilities - Qlik-  OWM Resolved ExportsupportHighALM# 27202/16/2017
2/1/2017Sriram S5PECOPresentationEnhancementLowALM# 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.

sunny_talwar

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

Anonymous
Not applicable
Author

sunny,

Tracking table is task basics.

Timesheet table is daily work basics related to task.

Anonymous
Not applicable
Author

Sunny,

     Till now both these tables are not mapped in anyway. so can you give me a suggestion of how can be mapped it.

sunny_talwar

Unless I know how you came up with the desired output, I am going to give this to you:

Table:

LOAD RowNo() as JoinField,

        Opco,

          Priority,

          ....

FROM Tracking-Table;

Join (Table)

LOAD RowNo () as JoinField,

          Date,

            time type,

            .....

FROM Timesheet-Table;

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

Or otherwise u know any data repairing method in tracking table. Is possible?