topic Re: how to map the both table without any same column and field in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

sunny_talwar — Thu, 16 Feb 2017 11:52:18 GMT

What is the desired output from the sample provided above?

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

Anonymous — Thu, 16 Feb 2017 11:59:21 GMT

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.

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

sunny_talwar — Thu, 16 Feb 2017 12:03:44 GMT

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

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

Anonymous — Thu, 16 Feb 2017 12:08:30 GMT

sunny,

Tracking table is task basics.

Timesheet table is daily work basics related to task.

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

Anonymous — Thu, 16 Feb 2017 12:13:23 GMT

Sunny,

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

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

sunny_talwar — Thu, 16 Feb 2017 12:18:51 GMT

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;

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

Anonymous — Thu, 16 Feb 2017 12:29:38 GMT

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.

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

Anonymous — Thu, 16 Feb 2017 12:32:26 GMT

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

topic Re: how to map the both table without any same column and field in QlikView

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

Opco

Priority

Startdate

Enddate

ALM/SLA

task Type

Date

time type

Resource

Hours

company

work area detail

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

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

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

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

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

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

Opco,

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

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