Good morning!
I am trying to create a new data table that pulls the average wind speed for each minute. My issue is that the data is being captured every few seconds. I need to figure out a way to export a table that shows the average wind speed for each minute of the data and also a table that shows the maximum wind speed for every minute. Can anyone help?
Thanks so much in advance!
Best,
Bobby
Solved! Go to Solution.
Hi @GIS_User01 ,
Please find attached a sample solution to do this using the text to columns tool. You can also do the same using RegEx.
Do let me know if this helps.
Best,
Jagdeesh
Hi @JagdeeshN ,
I appreciate the help and you have helped me tremendously! I went ahead and added in the hour as well so that I can rebuild a date/time field to associate with those average and max values. Do I use a RegEx to get that info concatenated together into a new date/time field? Can you assist with that as well?
Thank you for providing this! I'm sure this will prove useful in my current class as we're learning about Alteryx.