Unable to use Find and Replace function
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Join
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, try to change the data type to string, it should work!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @JLEE038 I mocked up a workflow that should produce the output as described by you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks all managed to figure out !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
