Identify start and end of sales

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)

hi @Sivasanmugam.

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)…

Greetz, Tommy

3 Likes

@tommy . Indeed. Many thanks. Seems obvious when I look at the workflow.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.