without common fields mapping is possible or not

[Anonymous]

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.

[vishsaggi]

What should be your expected output?

You can merge the tables using Concatenate.

Table1:

...

...

Concatenate

Table2:

...

...

[aarkay29]

May be

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

[Anonymous]

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.

[Anonymous]

i tried it but not mapped perfectly

[aarkay29]

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!!!

[vishsaggi]

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.

[vishsaggi]

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

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

[Anonymous]

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

[aarkay29]

Yes, thanks for correcting me Vishwanath, I overlooked  it