Parse figures in columns of another dataset

[Ben92500]

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

[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

[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!

[Emil_Kos · Accepted solution]

Hi @Ben92500,

small changes in the workflow:

The output:

[afv2688 · Accepted solution]

Hello @Ben92500,

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

Regards

[Ben92500]

Thanks to both of you, it was exactly what I was looking for !

I was wondering if it was possible to keep the name of the first column ("Data Columns") of my dataset, or should I just add manually the name in the "header" data set in the first line.

Let me know if it isn't clear

Benoit