I have a pipeline that reads a Splunk report, converts to CSV and uploads to Azure SQL.
One of the columns of my CSV is called _time. All the values of _time are from the same day: 2020-06-01T13:23:22.321 -04:00 where the first ten characters (i.e. “2020-06-01” are identical in the whole column. So, I would like to grab the first value and take the first ten characters to use them down the pipe for my Azure SQL db name (i.e. dbo.temp_dailies_2020-06-01).
Can you suggest a way to do so?
Sample of my CSV:
I have done some progress using the Unique snap… Am trying to figure out how to bring it to my main pipeline…
Here I get the unique “2010-06-01”
Basically I kinda need to merge the two… I think… Or any other suggestions are welcome