addition of weeks column to month column

KNIME Analytics Platform
#1

Weeks data.xlsx (10.4 KB)

Hi All,

I would like to convert weeks data mentioned in column to month.
i have attached file for an example.

Could you please suggest me how to do it.

#2

hi @nmajidkh,

you have to create a full table of week no. and months first.
Afterwards you can assign the month to your week-column (better: converted to rows).
So at the end you can aggregate / sum.

check my wf on the KNIME hub…

Hope, that helps, Tommy

5 Likes
#3

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