Match Description & Amount
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
rocco_romagnolo
5 - Atom
09-09-2022
09:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Fuzzy Match
1 REPLY 1
grazitti_sapna
17 - Castor
09-09-2022
09:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@rocco_romagnolo , Can you explain the things better with an example having your input data set and expected output.
Thanks!!
Sapna Gupta
