Fill in existing data by matching value from a column in another input

Jimmylee4real

hi all Alteryx Experts, 

I feel like this might be a common question which there had been loads of discussion going on but i was not able to find a solution to my specific use case after searching. 

I have an existing records after many formulas and tools on Alteryx but now I need to amend or fill in one single column to the existing records based on 3 criteria or matching values. 

I tried to use join the union or join function but the result is not as expected. 

For example: 

Current Records in Alteryx: 

Test Name	Test Systems	Test Date	Time (missing)	Recommendations (not relevant)
Tony	Photoshop	01 Mar		asdfasdf
Peter	Adobe	02 Mar		asffdsg
Johnny	Excel	03 Mar		gfhfghf
Mary	Python	04 Mar		sfgfsdfg

New Records: 

Test Name	Test Date	Time (want to append to original result)	Recommendations (not relevant)
Tony	01 Mar	15:00	asdfasdf
Peter	02 Mar	16:00	asffdsg
Johnny	03 Mar	19:00	gfhfghf
Mary	04 Mar	20:00	sfgfsdfg

Desired Results: 

Test Name	Test Systems	Test Date	Time (added here)	Recommendations (not relevant)
Tony	Photoshop	01 Mar	15:00	asdfasdf
Peter	Adobe	02 Mar	16:00	asffdsg
Johnny	Excel	03 Mar	19:00	gfhfghf
Mary	Python	04 Mar	20:00	sfgfsdfg

so basically i am trying to add the "column time" to existing records once the Test name, Test Date and Test systems are matching. thanks 

please advise! thank you Alteryx Community! 

paulfound

Hi @Jimmylee4real 

There are 3 outputs from the join tool and here I union L & J together, this is essentially a Left Join in SQL.

If your records are missing they will be in L,J or R.

If this doesn't fix it maybe share a screen shot? If it does fix it please mark as complete.