Match Function for values in Alteryx

[igorfv]

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

[gabrielvilella]

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.

[grazitti_sapna]

@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!

[Qiu]

@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.