How to get rid after using join as VLOOKUP in Alteryx? duplicate records appearing.

[kapilthakur]

Hi everyone,

Let me share the source data.

Source 1:

Emp_ id	Name	Date	Business	Location
879362	Ashish P	10/08/2023		OFFICE
879362	Ashish P	11/08/2023		WFH
879362	Ashish P	12/08/2023		WFH
879363	Kapil T	10/08/2023		OFFICE
879363	Kapil T	11/08/2023		WFH
879364	Anand S	10/08/2023	ABC	OFFICE
879364	Anand S	11/08/2023	ABC	WFH
879365	Priya T	10/08/2023	CDE	WFH
879367	Deepika K	10/08/2023	EFG	WFH
879367	Deepika K	11/08/2023	EFG	WFH

Need to apply VLOOKUP on another source where I have information of EMP_ID with groups. 

Source 2:

EMP_ID	Business	Age
879362	CMT	29
879364	ABC	27
879365	CDE	30
879367	EFG	35

If I use join (as a VLOOKUP) it will give me output for EMP_ID 879362 with appropriate Business. For EMP_ID 879363 It would not give any value in business.

I have another source in which for 879363EMP_ID 879363 is available and need to do again VLOOKUP!

Source 3:

EMP_ID	Business	Age
879363	GES	35

What to do in such case. Can anyone help me with their opinion?

It's a sample data in real it has around 30k records. 

I observed that after using Join we get repetitive same records.  

Sample output-

Emp_ id	Name	Date	Business	Location
879362	Ashish P	10/08/2023	CMT	OFFICE
879362	Ashish P	11/08/2023	CMT	WFH
879362	Ashish P	12/08/2023	CMT	WFH
879363	Kapil T	10/08/2023	GES	OFFICE
879363	Kapil T	11/08/2023	GES	WFH
879364	Anand S	10/08/2023	ABC	OFFICE
879364	Anand S	11/08/2023	ABC	WFH
879365	Priya T	10/08/2023	CDE	WFH
879367	Deepika K	10/08/2023	EFG	WFH
879367	Deepika K	11/08/2023	EFG	WFH

[binuacs]

@kapilthakur one way of doing this

[PhilipMannering]

If you're looking to overwrite the original [Business] column you can deselect it in the Join Tool.

If you're getting duplicates then you have duplicates in the source data. I would combine Source 2 and Source 3 first → remove duplicates (prioritizing the file you want to keep) and then Join. Here's my solution attached,