Hi All
I would like to share with the community one issue that I am experimating when I apply a VLOOKUPwith Allteryx.
First at all, let me introduce the necessary data that I am trying to cross:
TABLE 1: shows a list of materials (A, B & C) but the Source of Manufacture Code is not assined = #.
| MATERIAL | Source Of Mnf Code |
| A | # |
| B | # |
| C | # |
TABLEL 2: shows in which location codes are being manufactured each material, and I sorted this data based on the code which has more sales.
| MATERIAL | Source of Mnf Code 2 | Total Sales |
| A | 4356 | 5.000.000 |
| A | 4121 | 200.000 |
| B | 1789 | 400.000 |
| B | 1406 | 2.000 |
| C | 4513 | 1.000.000 |
| C | 4512 | 5.000 |
When you sorted the find table date and apply a VLOOKUP with Excel, the formula return the first row found (previously sorted by Main Sales Criteria). So, the VLOOKUP results in Excel will be:
| MATERIAL | Source of Mnf | Source of Mnf 2 |
| A | # | 4356 |
| B | # | 1789 |
| C | # | 4513 |
To make it with Alteryx Deigner I am using a Find & Replace Tool but the results are not being as I expected based on Excel exeriences. Aalteryx is returning the first Source of Mnf 2 that it found, indepentdenly of the sorted criteria applied.
You can find a simple example of the setting that I am applying in attachec designed and, here you can see that Alteryx results does not applied the sorted criteria in the source table.
I appreciate if you can share with me your suggestions and opinions to solve it.
Thank in advances.
Laura.
