Hi Guys, I am new to Alteryx, I am struggling with excels xlookup in Alteryx. Not getting any idea how to apply in alteryx flows. I have three tables. HEAD, MASTER and ITEM. I have made the below table (Solution Table) with applying vlookup & lookup in excel.
The required table should be same it is given in Solution table. I have got all the required columns in Alteryx flow. But the only part I am struggling on is the xlookup part which is applied on Required Qty column for which image has been attached. Also other files have been attached. It would be really grateful if anyone can help me with this Xlookup problem.
@griffinwelsh
i guess you missed the solution sheet attached
he wants to generate a now column which was generated on basis
excel lookup formula which is to be replicated in Alteryx
=IF(AND(B2="RAW_MAT",G2="KG"),(H2/100)*XLOOKUP(A2,D:D,H:H),IF(E2="X", VALUE(H2), H2+(H2*(F2/100))))
@griffinwelsh
i think you have added the old file again.
Thanks you're right. I updated the post with the correct workflow.
Thank yo Very much I got the Required Qty. However there is one more column to be added in the solution i.e Component Material type i.e D column in the solution excel that I have attached. The same xlookup is applied over the column to fetch Material type and assign it to respective Component. This is very small data but Currenct data is very large around 5lakh records. I tried joining tables again but not getting required results. I am attaching the excel with added column and required screenshot.