Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Unable to use Find and Replace function

JLEE038
7 - Meteor

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:

 

DateRate MonthBgn 10 DaysBgn 20 daysEnd 20 daysEnd of Month
12/30/2018  Jan-191/1/20191/11/20191/21/20191/31/2019
1/6/2019  Feb-192/1/20192/11/20192/21/20192/28/2019
1/13/2019  Mar-193/1/20193/11/20193/21/20193/31/2019
1/20/2019  Apr-194/1/20194/11/20194/21/20194/30/2019
1/27/2019  May-195/1/20195/11/20195/21/20195/31/2019
2/3/2019  Jun-196/1/20196/11/20196/21/20196/30/2019
2/10/2019  Jul-197/1/20197/11/20197/21/20197/31/2019
2/17/2019  Aug-198/1/20198/11/20198/21/20198/31/2019
2/24/2019  Sep-199/1/20199/11/20199/21/20199/30/2019
3/3/2019  Oct-1910/1/201910/11/201910/21/201910/31/2019
04/28/2019  Nov-1911/1/201911/11/201911/21/201911/30/2019
05/05/2019  Dec-1912/1/201912/11/201912/21/201912/31/2019

 

Source Data 2 : 

 

clipboard_image_0.png

4 REPLIES 4
Ladarthure
14 - Magnetar
14 - Magnetar

Hi, try to change the data type to string, it should work!

JosephSerpis
17 - Castor
17 - Castor

Hi @JLEE038 I mocked up a workflow that should produce the output as described by you.

JLEE038
7 - Meteor

Thanks all managed to figure out ! 

Cesarimbelloni
5 - Atom

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? 

 

Cesarimbelloni_0-1611075526978.png

Best,

Cesar

Labels