Rows to columns

[cpauly93]

Hi everyone,

I would need your support on the following:

I want to transform the values of one column into several columns.

More specifically, I would like to generate a column for each of the terms (servic, employe, busi etc.) and then display the frequencies by company/file name.

Example:

I’ve tried the “One To Many” node, but this node only creates binary (0;1) values.

Thanks for your help!

This is the current status:

[HansS]

Hi @cpauly93

Did you check the Pivoting node. GroupColumn =Term ; Pivots = File name ; Manual Aggregation = TF
gr. Hans