How understand a good granularity for analysis

Hi, I'm new of knime. I have a transaction dataset: Sold, Decription Item*, Sottocategory*, Category*, Segment*.

The attribute * are hierarchical. I want understand a good granularity for analysis, In order to reduce dimensionality.

Is there any node or metanode that help me in this questions?

 

You would first have to pivot or aggregate the table to get more features per row to perform reduction on. GroupBy (concatenate or sum methods) or Pivot to manipulate your data in such a way. At some point, you may also want analyze the transaction data by category, segment, etc. without losing the micro data. In this case, Group Loop may prove useful

Ok thanks