Transpose and rename rows to field

[chvizda]

Hi all

I have following data.

One set of data are the 10 entries "ws_els_Z.xxxxx" where Z is the counting for one set of data (from 1 to ZZZ).

Now I want to use these 10 rows as fields, but without the Z numbering. The unique index field is the "ws_els_subnet" + a datetime field (will be created automatically).

Or in other words: need to transpose and  rename the 10 columns. The data for every subnet must then be in 1 row with 10 fields. Would this be possible ?

Many thanks in advance

Steffen from VizDa

[jrgo · Accepted solution]

Hi @chvizda

This REGEX will parse the number and the last part, which would be your header to the value string. Example workflow also attached...

^.+?\.(\d+?)\.(.+)$

 

Hope this helps!

Best,

Jimmy

[chvizda]

Thanks, thats exactly what solves the problem.