Handling Missing Status in Data with Matching Product Codes for Aggregation
Hello everyone,
I have encountered an issue while working with a dataset and need some guidance. I have a table (Table 1) where each record is classified as either an "Order" or "Stock" in the "DataType" column. The "Stock" records do not have a "Status" value, but "Order" records do. I want to generate a summary table (like Table 2) that shows the total "Order" and "Stock" amounts for each "Status".
However, since the "Stock" records lack a "Status", they are currently being omitted in the summary, leading to "Stock Amount" being displayed as 0.
Unfortunately, I am unable to make changes in the data load editor, so I need to find a solution directly within the table or chart. Is there a way to link the "Stock" records to the appropriate "Status" based on the matching "ProductCode" from the "Order" records? I would like to treat them as if they are associated with the same "Status" for aggregation purposes.
I appreciate any advice or solutions you might have on this!
There doesn't seem to be a match with the ProductCode - you have the same ProductCode in multiple statuses - so you wouldn't be able to use that without duplication. Is there some other field available you might be able to use for this?
@ogulturkDogan1 I don't think you could do it in expression as Status is not tagged to Type='Stock'. You could somehow manage to get it if there is some field which uniquely identifies status (meaning that field values are unique for each status) for both of order and stock, but that will be more complicated if you have many status as you need to write separate expression for each status. Better solution will be fill the status values in script for stock
