โ06-03-2020 06:13 PM
Greetings,
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โฆ
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
Thank you,
Mitsos
โ06-17-2020 06:01 PM
Thank you very much - this has been very helpful!!