It sounds like a very simple problem, but I am stuck with it, probably due to my lack of knowledge.
I have a query that brings me daily volume (VOL_20) for each product (COD_PRODUTO). When there is no production for the day, the query doesn't bring any data.
I have an attribute for each product to show the value. I configured a Table lookup as below, matching product and locations.
The problem is, when there is no data for the day for a product, the query simply does not generate anything for this product. The table lookup keeps showing the last value. I want to show no value. How can I accomplish that?