Transpose and rename rows to field

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

Input

Tips and Tricks

Parse

Transformation

Accepted answers

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

All comments

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

Thanks, thats exactly what solves the problem.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15875

MarqueeCrew 13708

apathetichell 13703