Hello everyone,
I am pretty new to Knime and I am trying to achieve something which I assume is possible with Knime but unfortunately I have been struggling for long now.
I have an input excel file in the following format:
And I would like to transform it to the following format:
Would you please guide me on how to achieve that?
Thanks a lot.
Attached to the topic are the input and output files shown above in the screenshots.
Input.xlsx (9.4 KB)
Output.xlsx (9.6 KB)
Thanks for your reply but unfortunately due to the original data structure a transpose will not give the required output.
HansS
August 12, 2019, 12:37pm
4
Hi @amrzahran
Indeed the solution use the Transpose node. But the structure of the input file is a little bit complex. So I used the Chunk Loop .
and do some “stuff” along the workflow to get the column names and positions as in the output file.
Hope this helps.
data_transform_xls.knwf (65.7 KB)
gr Hans
6 Likes
Works perfectly. I am going through the nodes one by one to understand the manipulation in details.
Thanks a lot for your time
2 Likes
system
Closed
August 19, 2019, 12:51pm
6
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.