Match Function for values in Alteryx
- 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 Community,
How does Match function with values in Alteryx? Below are the formula (D3 cell) and excel file. Give me an example, please.
Thanks!
Igor Valle
- Labels:
- Predictive Analysis
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @igorfv, here is how I did this. Unfortunately there is no match function in Alteryx, you need to combine other tools to the to the result. One point of attention is that if you have a large table, this method will not be recommended as it will create too many records from the append fields tool. On this case, you will need an iterative macro to solve your problem.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@igorfv, there is no direct way of implementing the Match function in Alteryx. Here is an alternate method that could work for you.
Also, if this works please mark this post as a solution.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@igorfv
A batch macro is a good fit for the match index combination.
It gets a bit complex since you have error process and displacement.
