Hi Guys,
I am new to Alteryx and I am trying to perform a "VLOOKUP" equivalent function.
Below is the action that I will like to perform:
If Column - Date 2 ( Source Data 2) = Source Data 1 Column - Date , it will take the corresponding value from column F5 from Source Data 2 and place it on Source Data 1 Column (Rate )
Eg: For 2019-05-05 it will take 111.88 from source Data 2 and goes into Source Data 1 Column "Date" to find the matching date and placed 111.88 under Column "Rate"
I have tried to use the Find and Replace Tool but it did not work as the column "Date" did not appear on my drop down list for Find within Field.
In addition I am also unable to locate "Date2" under Find value. Could anyone advise on the issue ?
Source Data 1:
Date | Rate | Month | Bgn 10 Days | Bgn 20 days | End 20 days | End of Month | |
12/30/2018 | Jan-19 | 1/1/2019 | 1/11/2019 | 1/21/2019 | 1/31/2019 | ||
1/6/2019 | Feb-19 | 2/1/2019 | 2/11/2019 | 2/21/2019 | 2/28/2019 | ||
1/13/2019 | Mar-19 | 3/1/2019 | 3/11/2019 | 3/21/2019 | 3/31/2019 | ||
1/20/2019 | Apr-19 | 4/1/2019 | 4/11/2019 | 4/21/2019 | 4/30/2019 | ||
1/27/2019 | May-19 | 5/1/2019 | 5/11/2019 | 5/21/2019 | 5/31/2019 | ||
2/3/2019 | Jun-19 | 6/1/2019 | 6/11/2019 | 6/21/2019 | 6/30/2019 | ||
2/10/2019 | Jul-19 | 7/1/2019 | 7/11/2019 | 7/21/2019 | 7/31/2019 | ||
2/17/2019 | Aug-19 | 8/1/2019 | 8/11/2019 | 8/21/2019 | 8/31/2019 | ||
2/24/2019 | Sep-19 | 9/1/2019 | 9/11/2019 | 9/21/2019 | 9/30/2019 | ||
3/3/2019 | Oct-19 | 10/1/2019 | 10/11/2019 | 10/21/2019 | 10/31/2019 | ||
04/28/2019 | Nov-19 | 11/1/2019 | 11/11/2019 | 11/21/2019 | 11/30/2019 | ||
05/05/2019 | Dec-19 | 12/1/2019 | 12/11/2019 | 12/21/2019 | 12/31/2019 |
Source Data 2 :
Solved! Go to Solution.
Hi, try to change the data type to string, it should work!
Hi @JLEE038 I mocked up a workflow that should produce the output as described by you.
Thanks all managed to figure out !
Hi @JosephSerpis thanks for the example you uploaded, it helped me with a query I had as well!
May I ask you what is the "formula" tool with the rate = [F5] for?
Best,
Cesar