Create NoValue Rows according to two different timestamps

[TLG90]

Hello,

I have two Time/Value Pairs which are timestamp and for example voltage on different devices.

Of course there is the possibility that one of the devices isn't recording (for example the pc needs to reboot while the other one is still alive) or have some issues so there is a time gap.

How is it possible to fill the gap with NoValues so i can compare the values in the ChannelTable?

what I have is like this:

As can be seen the first timestamp starts about 26 seconds later than the second one.

I need to fill this with 26 rows of NoValues until both match the same second of recording. Here 13:34:53:xxxx 

Also can be seen there are gaps somewhere in between these columns because the difference of values is 2000+.

These gaps somewhere in between should also be NoValues if the timestamp doesn't exist in the first column.

I hope my problem is specified enough and not too unintelligible.

Thanks in advance

Thorsten

[Steve2m · Accepted solution]

Hello,

just tried this. You can use the ChnMapLinCalc function to do this, example:

Call ChnMapLinCalc(oChnT2, oChnU2, oChnT, oChnU3, False, "const. value", NV, "Spike", NV)

... where oChnT2 is the time channel with the gaps, oChnU2 the corresponding Y-channel, oChnT the reference time channel where you signal of the Y-channel should fit to and oChnU3 a new / empty channel where your Y-channel is mapped to.

Extrapolation and missing interim time values will be filled with NoValues.

Regards

Stephan

[TLG90]

That's almost the same as I tried. Just had "analogue" and thereafter 0, which made me the wrong output.

Thanks a lot.