Free Trial

Alteryx Designer Desktop Discussions

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

Match Description & Amount

rocco_romagnolo
5 - Atom

Dear all,

i am new to Alteryx and i am stuck at 1 problem. 

I am trying to match my account spreadsheet with following rule:

- The description needs have a fuzz match with 90% probability

- If description match then there needs to be an In (positive value) and an out (negative value) = to 0

- all matched should be sent into a different file

- all unmatched should be sent to a different file

 

see attached the sample data. 

 

Was reading through the community articles but couldn't find anything. Really appreciate your help. 

 

Thanks

Rocco

1 REPLY 1
grazitti_sapna
17 - Castor

@rocco_romagnolo , Can you explain the things better with an example having your input data set and expected output.

 

Thanks!!

Sapna Gupta
Labels
Top Solution Authors