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

Fuzzy Match Across Multiple Columns

Mike_at_CG
8 - Asteroid

Hi All

 

Hoping I can get some help from the community here.   Going to preface this with saying I am struggling to actually communicate what I am trying to accomplish.  I just have the idea in my head.

 

File 1 has securities data at a point in time.  In this case 1/1/1997.  To the right of that data I have a formula (done in excel) where I am looking to get the next price at point in the future.   I like to think of this as the horizontal file.

Mike_at_CG_0-1680019578407.png

 

File 2 has the individual security data at those further points in the future.  I like this think of this as the vertical file.

Mike_at_CG_1-1680019811567.png

 

The end result would be to match Symbol and Date across all the dates on the horizontal file.  Something that looks like this.

 

Mike_at_CG_2-1680019938326.png

 

Thank you for taking the time to read and any help you can provide.

2 REPLIES 2
gautiergodard
13 - Pulsar

Hey @Mike_at_CG 

If i understand correctly, I dont think you be using the fuzzy match for this scenario?

Instead, i think you would need to pivot file 1 so the data is displayed vertically, use 1 or more joins to get the relevant data from file 2, and then pivot you data back so it looks like the end result provided.

dhoover
5 - Atom

Hi @Mike_at_CG! I think you could also use the Transpose tool under the orange Transform toolkit to rearrange the data to get the result you are looking for, and then join the data strings with a Join tool or Join Multiple tool. Finally, you will want to rearrange the columns with a Select tool in order to have the proper order by date.

Labels