Time array to time column conversion plus adding data column

Hi all !

Can someone please suggest which nodes would be useful to achieve the following:

I have 5 minutes timeseries written like this

And I need to have them written like this


So, what I need is just two columns. Any ideas?

Best regards

Perhaps the Unpivot node may be helpful here. If not, could you attach sample data? Thanks!

1 Like

Hi @Dalmatino16,

@victor_palacios and I were thinking the same thing. See attached example.

Time Example Test.knar.knwf (13.0 KB)

Wali Khan


I actually went to far with my example and removed anything with a 0 value. You can remove the row filter (Node 8) and get the output you want.

1 Like

Hi, thanks Wali, looks good. Going to try it out on my data.

1 Like

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