Associate issue

[My_Rebecca]

The matching columns are "Material Document" and "GR Number" in two worksheets.

Now I want to create the new column E in first sheet to add "Truck Arrival Time" as following. 

I tried the "Associate" in Data Manager without success.

How to realize it in Data Manager? or Data Load Editor? Better 2 solutions are expected, thanks

[My_Rebecca]

new error:

The following error occurred:

Table 'Sheet1' not found

The error occurred here:

[Sheet1_temp_c7d84760-e024-33a8-eca1-bf2104cd]:

LOAD

[GR Number], [Truck arrival], [Material Description] AS [Sheet1.Material Description], [Material] AS [Sheet1.Material], [Plant], [Storage Location], [Movement Type], [Material Document], [Material Doc.Item], [Posting Date], [Time of Entry], [Special Stock], [Supplier], [Quantity], [Unit of Entry], [Amount in LC], [Purchase Order], [Item], [Sales Order], [Sales order item]

RESIDENT [Sheet1]

[MayilVahanan]

Hi

Sheet1 is renamed as "Table1".. Either you can change to "Sheet1" and in the resident load, you can change to "Table1"

[My_Rebecca]

next:

The following error occurred:

Field 'Truck arrival' not found

The error occurred here:

Left Join(Table1) Load "GR Number", Min("Truck arrival") as "Truck arrival" Resident Table1 group by "GR Number"

[My_Rebecca]

@MayilVahanan I would close this topic as from my learning, ApplyMap is more suitable for this duplicated target value, many thanks for your support.