load and interpolate .dat file

[VGEIEBau]

Hello,
I want to analyze data from two different sources. One source has a measurement frequency of 10 minutes and the other 30 minutes.
I would like to know if it is possible to load the data 30 minutes and insert by linear interpolation two additional points .

example raw data

18.01.2021 11:00:00, 10
18.01.2021 11:30:00, 40

...

desired result
18.01.2021 11:00:00, 10
18.01.2021 11:10:00, 20
18.01.2021 11:20:00, 30
18.01.2021 11:30:00, 40

...

thanks for your help

[VGEIEBau]

I forgot to specify I would like to open the .dat file in Diadem.

thanks

[panta1978]

Hi,

DIAdem comes vith a resampling function that might help you.

Let the input of your function be:

• Group1/Time1 be the row time scale [11.00, 11:30] - basically, the time sample of the acquisition with a raster of 30 minutes
• Group1/Val1 be the raw values [10, 40]
• Group2/Time2 be the time scale on which to reinterpolate your data [11.00, 11.10, 11.20, 11.30] - basically 

And the output:

• Group2/Val2 the desired output [10, 20, 30 ,40] - basically, the time sample of the acquisition with a raster of 10 minutes

You can write this vb code, and you'll have your 30-minute sampled variable resampled with a rate of 10 minutes.

Call ChnResampleChnBased("Group1/time1", "Group1/VAL1", "Group2/time2", "Group2/VAL2", "Automatic", False, False, "Akima")

About your second question. There are several different .dat file formats. I'm used to working with ETAS .dat file (standard automotive files), and they are managed by DIAdem. But there are many other different fomrats with .dat extension.
If there is a Data Plugin available, you'll probably be able to manage it.

I usually look for Data Plugin in this page, but it seems it has changed and there aren't all the plugins there used to be: https://www.ni.com/en/support/downloads/dataplugins.html 

Alternatively, you can go from DIAdem. Settings -> Extensions -> Data Plugin -> Add Data Plugin from Web [Arrow down]

Hope it will help.

 

[VGEIEBau · Accepted solution]

Right in the bull's-eye!
This is exactly what I was looking for, thanks for the quick and accurate answer!

For the second part of the question i have made a plugin with the wizard to load the data in the right form.

thanks a lot !