Combining Tables

Hi - I would like to know how to match data from 2 different tables and then join them.

For Example -

Table #1

Part (With version) | Quantity
ABB-V1 | 2
ABB - V2 | 3
CC-V1 | 1

Table #2 - Product Data Table

Base Part (W/o version) | MSRP
ABB | $184.00
CC | $120.00

Desired Outcome
Base Part | Quantity | MSRP
ABB | 5 | $184.00
CC | 1 | $120.00

Hi @AColvin6

I was thinking of something like this combining tables.knwf (12.4 KB)
Schermafdruk van 2021-08-11 18-09-17.
gr. Hans

6 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.