I am trying to build a pivot table from my source and then export it to excel. I do not want the pivot table to be made in excel, but it be fixed based on output from transformation. I've been looking around in Kettle and only found the "Row denormalizer" step that looked similar. However it seems to be pretty much fixed (columns need to be predefined, which I don't want). Any other way to do it that I would have missed?
I have a table with columns products, months and prices. My output table should have all products in rows, months in columns, and the related price at intersection. Every month new month will come in, and I want it to automatically add a column in my table. It doesn't sound so complex at first...