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:
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.
The short and sweet code as of now:
(ooxml, embedded labels, table is Sheet1);
SQL SELECT Nm,
LOAD distinct OrdNo,
R10 as SerialNumber;
SQL SELECT OrdNo,
Max(OrdNo) as OrdNo
where SerialNumber > 10
Group By SerialNumber Order By SerialNumber asc;
DROP Table Order;