knime categorical column sub merged

Hello,
taking a categorical features ordered sequentially (eg. AAAABBCCC) how can I merge the cells that have the same name? (see the attached file)
Is there a workflow that allows you to do this formatting?
example.xlsx (8.7 KB)

Hello,

The Groupby node will do that.

2 Likes

Hi Victor,

maybe I explained bad.

It is a formatting problem, not a data aggregation problem.

I need to merge the cells vertically that have equal values ​​(formatting problem that I solve by doing it manually) while I believe that “group by” only allows you to aggregate leaving the vertical formatting not aggregated. But maybe I’m wrong … is possibile with “group by” to merge the cells vertically?

I think you are looking for this:

1 Like