Applymap- wants to fetch more than 1 possible value

[khajafareed]

i have below tables:

Table 1:

Number	Priority	Category	Caller	Caller User ID
INC0022977	3 - Moderate	Product Functionality	Moogsoft Integration User	moogint
INC0022976	3 - Moderate	Access	Jamar Henderson	Jamar.X.Henderson
INC0022975	3 - Moderate	Product Functionality	Moogsoft Integration User	moogint
INC0022974	3 - Moderate	Product Functionality	Moogsoft Integration User	moogint

Table 2:

Task	Target	Stage	Has breached
INC0010595	Response	Completed	TRUE
INC0021419	Response	Completed	TRUE
INC0015848	Resolution	Completed	TRUE
INC0012613	Response	Completed	TRUE

When I try to use applymap, I am only able to fetch the first possible value it finds (I understand this is how applymap works).

But I would like to fetch all the data i.e all the corresponding values for a particular Number.

For Number i need the values "Resolution" and "Response" from Table 2.

How can I do this?

[Taoufiq_Zarra]

@khajafareed  can you share also the expected output

[khajafareed]

INC0010012	Response	Completed	TRUE
INC0010012	Resolution	Completed	FALSE
INC0010014	Resolution	Completed	FALSE
INC0010014	Response	Completed	FALSE

[Taoufiq_Zarra]

@khajafareed  can you elaborate ?

Table 2 is the input table or the output table (result) ?

[khajafareed]

Table 2 is input table, While i am looking for Column(Number from table 1) it should populate both values (Response and resolution) from Table 2 Column(Target)

[Kushal_Chawda · Accepted solution]

@khajafareed  Why don't you just join them like below? Assuming Number from Table1 and Task from Table 2 are common

Table1:
LOAD Number,
Priority,
Category,
Caller,
[Caller User ID]
FROM
[https://community.qlik.com/t5/QlikView-App-Development/Applymap-wants-to-fetch-more-than-1-possible-...]
(html, utf8, UserAgent is 'Mozilla/5.0', embedded labels, table is @1);

Left join(Table1)
Table2:
LOAD Task as Number,
Target,
Stage,
[Has breached]
FROM
[https://community.qlik.com/t5/QlikView-App-Development/Applymap-wants-to-fetch-more-than-1-possible-...]
(html, utf8, UserAgent is 'Mozilla/5.0', embedded labels, table is @2);

[khajafareed]

Sorry for responding late.

I already tried Joining both tables, my issue is to fetch the latest Response/Resolution Breached status from Table 2.

As one incident will have more than one possible Response/Resolution values, from this i need to fetch the latest record not the first record.