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]

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.