Parse figures in columns of another dataset

Hello

I'm a newbie. I'm trying to parse data and applying columns name from another dataset.

Basically I have one data set where I have all my columns name

A	B	C	D
0	0	0	0

Another one where I have my data

Data column

Data 1 2 3 4

Other data 1 2 3 4

More Data 1 2 3 4

I have been able parse data using regex tool separating text from figures. My issue is that I have to rename manually my columns in the regex output tool instead of applying automatically the columns names from my 1st dataset.

I would like my output to be like this:

Data column	A	B	C	D
Data	1	2	3	4
Other data	1	2	3	4
More Data	1	2	3	4

Thanks for taking the time to answer me

Benoit

Parse

Transformation

Join

Accepted answers

Emil_Kos

Hi @Ben92500,

small changes in the workflow:

The output:

Rename.yxmd

afv2688

Hello @Ben92500,

hope it helps now. I think what you want to use in this case is the dynamic rename tool.

Regards

parse data.yxmd

All comments

afv2688

Hello @Ben92500,

Depending on how the data really is the process can change a lot.

Anyways, here is a way to do it.

Regards

parse data.yxmd

Ben92500

Hi @afv2688

Thanks for your help!

The data is composed of a text description followed by numbers separated by spaces.

I've attached below a workflow of what I'm trying to achieve

I would like to paste automatically the headers made with the crosstab on the result of my parsing with regex. Let me know if it isn't clear!

Combine_headers_data.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703