AnsweredAssumed Answered

AF Table lookup and daily Query: show zero when no value is found for the day

Question asked by MISugiyama on Jan 29, 2019
Latest reply on Feb 4, 2019 by gregor

Hi!

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?

Outcomes