topic Re: without common fields mapping is possible or not in QlikView

without common fields mapping is possible or not

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

Hi,

I have two tables but there is no common field to map that two tables, there is any other way to map the two tables.

Table1:

Business	Priority	Issue Identified_date	SLA _date	Issue_ID	Status
PECO	High	2/5/2017	2/12/2017	ALM1254	In Progress
ComED	Low	2/8/2017	2/15/2017	ALM142	closed
PECO	High	2/12/2017	2/18/2017	SUR1247	Ready
ComED	Low	2/14/2017	2/21/2017	IMI165	Waiting for Input

Table2:

Date	Resource	Hours	Work Area	work Detail
2/6/2017	Ram	8	Qlikview-PECO	working on enhancement
2/7/2017	Ranjit	8	Qlikview-ComEd	working on dashboard
2/8/2017	Durga	8	Qlikview-BGE	working on presentation
2/9/2017	Irshad	8	Qlikview-PECO	working on extraction
2/10/2017	Shakila	8	Qlikview-PECO	working on enhancement
2/11/2017	Ranjit	8	Qlikview-ComEd	working on dashboard
2/12/2017	Durga	8	Qlikview-BGE	working on presentation
2/13/2017	Irshad	8	Qlikview-PECO	working on extraction

from above two tables i have to map into single table.

Re: without common fields mapping is possible or not

vishsaggi — Thu, 16 Feb 2017 14:34:24 GMT

What should be your expected output?

You can merge the tables using Concatenate.

Table1:

...

Concatenate

Table2:

...

Re: without common fields mapping is possible or not

aarkay29 — Thu, 16 Feb 2017 14:34:37 GMT

May be

Subfield([Work Area],'-',1) and Business

Re: without common fields mapping is possible or not

Anonymous — Thu, 16 Feb 2017 14:41:22 GMT

if that two tables mapped into single table means i will find which resource is working on that particular issue and what is status of that and how many hours they are working on it like that i have to track.

Re: without common fields mapping is possible or not

Anonymous — Thu, 16 Feb 2017 14:42:23 GMT

i tried it but not mapped perfectly

Re: without common fields mapping is possible or not

aarkay29 — Thu, 16 Feb 2017 14:47:54 GMT

May be this if you want to see it by Business

Upper(Subfield([Work Area],'-',1)) and Upper(Business)

Also there will be null for QLIKVIEW-BGE as it is missing in Table1

If you expect different results can you please provide me a sample how you would like to see it!!!

Re: without common fields mapping is possible or not

vishsaggi — Thu, 16 Feb 2017 14:56:53 GMT

Is this the real data? Coz if you have to find out which resource is working on which issue you should have some kind of relationship between two tables? Can you tell us is this data coming from an excel or any other data source. If you tried Aar 's subfield it will map but i can see the Business field has ComED which has uppper case ED but in your workarea field you have Ed with lower case d.

Re: without common fields mapping is possible or not

vishsaggi — Thu, 16 Feb 2017 15:01:22 GMT

Aar i believe it should be 2 in your subfield. Like

Subfield([Work Area], '-', 2) will give you the business names mapping to table1..

Re: without common fields mapping is possible or not

Anonymous — Thu, 16 Feb 2017 15:03:18 GMT

ComEd - this is right, ComED- wrong ignore it, both source's are come from excel file only.

Re: without common fields mapping is possible or not

aarkay29 — Thu, 16 Feb 2017 15:04:01 GMT

Yes, thanks for correcting me Vishwanath, I overlooked it

Re: without common fields mapping is possible or not

vishsaggi — Thu, 16 Feb 2017 15:16:51 GMT

Ok then just use Subfield() as mentioned by Aar with delimiter '-' and index as 2. This way if ED is not Matched with Ed it will not count. Just try that let us know.