Sorry for the non-KNIME specific question. But I wasn’t sure where to look for help and this comminuty is so helpful. And untimately it’s for solving a modeling problem.
I have Company (and this likely applies to User data as well). The usual stuff you would find on D&B (Industry, revenue and other financials, number of employees, technolgies used, etc). These are typically stored in a CRM as the most recent (current) data. The problem is if we are modelling with data from years ago these values would have been different (especially in high tech… these change fast).
How should these values be stored in a databse and the appropriate ones used when modeling over multiple years of data? Do I create a new table with historical values on these key fields and treat it like a log table?