Rows to columns

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.

Screenshot 2020-03-17 at 16.40.27

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:

Hi @cpauly93

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


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.