topic Re: Best approach to join incomplete time series data in Alteryx Designer Desktop Discussions

Best approach to join incomplete time series data

mi_schmidt — Mon, 09 Mar 2020 14:57:17 GMT

Hi Alteryx Community,

I'm often challenged with time series data from sensors where the sensors just send a new value when a hange has happend. That results in arbitrarily time intervalls between two values. My goal is to analyze and visualize (in Tableau) the dependency of multiple parameters from different data streams.

So far I joined two of those data streams with a generated list of time steps, e.g. for each minute. Unfortunately, the complexity raises when additional parameters (in this example the Pos) come into account.

Do have any proposal to improve my current approach?

Thanks in Advance for your help

Michael

Re: Best approach to join incomplete time series data

echuong1 — Mon, 09 Mar 2020 15:01:37 GMT

Have you looked into the TS Filler tool? This will help fill in any gaps within your data.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-TS-Filler/ta-p/84642

Re: Best approach to join incomplete time series data

mi_schmidt — Mon, 09 Mar 2020 15:12:24 GMT

Hi,

Thanks for your quick response.

I haven't used the TS Fill+er tool yet and will give it a try!

Thanks

Michael

Re: Best approach to join incomplete time series data

RolandSchubert — Mon, 09 Mar 2020 15:12:48 GMT

Hi @mi_schmidt ,

in my understanding, you have different sensors (A, B) at different positions (110, 115, 121) sending a signal, if change hanppens. If that is true, you could use a Multi-Row Formula tool to fill the gaps (sensor B at position 110 as the specific values at 00:26:00 until 01:00:00, this is the next entry, values unchanged, Multi-Row Formula could fill in the values registered at 00:26:00 up to 00:59:00, repeat the process starting at 01:00:00 to the next entry).

But - to be honest - I was only guessing, so a little bit more backgroupn would be helpful. What do you think?

Best,

Roland

Re: Best approach to join incomplete time series data

mi_schmidt — Mon, 16 Mar 2020 11:13:55 GMT

Hi @RolandSchubert,

thanks for your help.

Your assumptions are completly right and the solution should work as well. I tried the TS Filler and could achieve the desired results.

Best

Michael