About Vlook up function

[jeffwongarrow]

Dear All

I am trying to use a vlook up function which I believe joint tool will help, but somehow I am not about to sort it our smoothly.

Here is the original data from last week sample

Name	ID	Grade on 3 Nov	Grade on 27 Oct	Grade on 20 Oct
Company A	122622456	08	08	08
Company B	117349213	06	06	06
Company C	91422092	05	05	05
Company D	117339904	06	06	06
Company E	6417458	06	06	06

this is the data I want to look up with this week

Name	ID	Grade on 10 Nov	Grade on 3 Nov	Grade on 27 Oct	Grade on 20 Oct
Company A	122622456	08	[Null]	[Null]	[Null]
Company B	117349213	06	[Null]	[Null]	[Null]
Company C	91422092	05	[Null]	[Null]	[Null]
Company D	117339904	06	[Null]	[Null]	[Null]
Company E	6417458	06	[Null]	[Null]	[Null]

in this original file, I need to lookup up to beginning of 2020 with thousands of record by look up "ID", appreciate everyone help as always

[atcodedog05]

Hi @jeffwongarrow 

When you say beginning of 2020 what do you mean?

[atcodedog05]

Hi @jeffwongarrow 

Is this what you are looking for

Here is a workflow for the task.

Input : Data given

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Hi @jeffwongarrow 

Here is an alternative workflow just in case if you are using Old version of Alteryx

Hope this helps 🙂

[jeffwongarrow]

Hi Atcodedog05

Thanks for your help,

it seems that in the Joint section you use "name" to look up the grade, but I will like to use "ID" to look up instead, is there any change of setting in this case?

thanks

[atcodedog05]

Hi @jeffwongarrow 

By bad just changed it. Just need to change like below

Make sure the datatype of ID is same.

On my first workflow it was ID only second by mistake i set it as Name😅

First workflow uses a new feature which was released in the new verison.

[jeffwongarrow]

Hi Atcodedog05

I am trying to use the attached file to working on vlookup based on your advise, but I am not able to breakthrough the joint section, appreciate your help to have a look,  sorry to keep bothering you

[atcodedog05 · Accepted solution]

Hi @jeffwongarrow 

Hope this meets the requirement.

Here is a workflow for the task.

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @jeffwongarrow 

Cheers and Happy Analyzing 😀