Extract single line CSV data into multiple columns

[andre_vdveen]

Hi, I'm trying to get the data in a CSV log file split into separate columns, but I'm stuck with DQL/DPL.
Any help would be super appreciated!

Also, I assume I'd need a metric for each column if I want to get the values onto a dashboard, right?
Each value separated by a comma, needs to fall into the columns below.

Here's the raw data - the masked text goes with 'Claims' or 'Batch Claims' and is called the 'Component' in the example above:

[andre_vdveen · Accepted solution]

Figured the 1st part out, with some help:

parse (content, "(LD:dup_timeStamp LD:component FLOAT:AvgTime INT:NoOfClaims INT:WorstTime INT:Time_Outs INT:Exceptions FLOAT:Standin )(fs=',')")

[y_buccellato]

I'm in a similar situation.
Kinda surprise that with all the DQL power you cannot auto parse a field which contains multiple value divided by comma ",".
My love for excel still persist 😄