I have a product list with the sales data per month in columns. I need to identify the start of sales and end of sales per product. How to do it in Knime?Identify SOS and EOS.xlsx (9.3 KB)
in that case you have to get rid of the matrix format.
Unpivoting does that for you and afterwards you can get the min/max date with the help of the group by-node. Please check this workflow on KNIME hub (drag&drop)…
@tommy . Indeed. Many thanks. Seems obvious when I look at the workflow.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.