I habe multiple csv files, each having the same columns and rows, like:
File1
Time Pwr1 Pwr2
1:00 100.0 50.9
2:00 150.5 86.6
3:00 200.4 45.2
File2
Time Pwr1 Pwr2
1:00 120.4 54.5
2:00 230.4 45.3
3:00 245.1 23.8
I want to create a new csv file with the following scheme:
Time Pwr1(file1) Pwr1(file2)
1:00 100.0 120.4
2:00 150.5 230.4
3:00 200.4 245.1
With “List Files” → “Table Row To Variable Loop Start” → “File Reader” → “Loop End” I get
Time Pwr1
1:00 100.0
2:00 150.5
3:00 200.4
1:00 120.4
2:00 230.4
3:00 245.1
I have tried several examples and solutions, but have not yet come to a satisying solution.
Any suggestion and hint is appreciated.
Greetings
Daniel