Is there any way to flatten data in knime.
I have multiple rows from the database containg and id for different places, and I want to transfrom this into having multiple columns, with the column name, place_id_1, place_id_2 and so on. For flattening data. I want to make the data for each row be for each year of the then have all the places visited that year in the same row as differant attributes.
Is this something that can be done in KNIME? or do anyone have any good tip how to do this?