I have been stuck trying out several different solutions for my issue, but can't seem to figure out where I am going wrong:
I have 3 table:
Excel spreadsheet with 2 data points (Machines)
DB with three data points (Order)
DB with two data points (Customer)
I have already matched up the serial numbers in Machines and Order to give me a unique Order number based on the Serial number by using NoConcatenate and dropping the order table.
The problem I am facing at this point, is that the Customer table has nothing to match with when the Order table is dropped and therefore gives me rubbish when I add the Customer name to my visualization.