Time array to time column conversion plus adding data column

[Dalmatino16]

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

[victor_palacios]

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

[wkhan]

Hi @Dalmatino16,

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

Time Example Test.knar.knwf (13.0 KB)

Regards,
Wali Khan

[wkhan]

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.

[Dalmatino16]

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