How to Apply Xlookup with Following condtions.

Question

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.

Solution.xlsx

MASTER.xlsx

ITEM.xlsx

HEAD.xlsx

Capture.png

Riox078 · Answer

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.

Solution - Copy.xlsx

griffinwelsh · Answer

Thanks you're right. I updated the post with the correct workflow.

Raj · Answer

@griffinwelsh 
i think you have added the old file again.