Icon

Join Excel and VLookup KAP4.x

demo lookup excel and join

There has been no description set for this workflow's metadata.

Setup the data Read the "stock"sheetStock PriceNode 3Quantity OrderedNode 5Read the "orders"sheetjoin on productcalculate price * qtywrite back to the Order sheet Excel Reader Table Creator Excel Writer Table Creator Excel Writer Excel Reader Joiner Math Formula Excel Writer Setup the data Read the "stock"sheetStock PriceNode 3Quantity OrderedNode 5Read the "orders"sheetjoin on productcalculate price * qtywrite back to the Order sheetExcel Reader Table Creator Excel Writer Table Creator Excel Writer Excel Reader Joiner Math Formula Excel Writer

Nodes

Extensions

Links