expand a range/series into columns
Hi there - learning Knime! and I am totally stuck on an item.
Here is the Knime data I have gotten up to:
CustomerID, and range of years:
And I want to get to a final solution of :
Problem:
So for example customerID 8152 has set year ranges defined as: 2011-2011, 2011-2014, 2013-2015:
Solution
2011-2011 → column 2011 and cell gets populated with 2011
2011-2014 → columns 2011, 2012, 2013, 2014 and cells get populated.
2013-2015 → columns 2013, 2014, 2015 and cells get populated.
Note: There could be year gaps for some customer IDs. So its not necessary that a Customer ID will always have contigious years, but could have a gap year.
Totally lost on how to approach this problem.
I am a beginner with Knime ( learning on my own time for a non-profit org).
Any help would be great!