In the capture below, I have an input file that is composed of several groups with repeating information. The problem I have is that in several groups, there are several values that have the same field.
When I use the pivot nodes and ungroup, the field whose values are repeated, appear only in one column.
Is it possible to make this field appear in two columns?
Thank you, for your constructive answer.
and welcome to kNIME Community!
Where do you loose values 2? In Pivoting node? And where do you have your Group information? In Another column? I would try List aggregation in Pivoting node and then Split Collection Column node but not sure on your exact data structure so this might not work. Can you share input data sample and desired output? Dummy works just fine.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.