Split column header

[barbaracnx]

I need to split a column based on the header. I need the header to be in two separate columns

right now it reads:

I need it to be two columns, one called Net production MMCF and one called 1906 base case. The data does not matter I 

[JosephSerpis]

Hi @barbaracnx I mocked up a workflow let me know what you think?

[jrgo]

Hi @barbaracnx 

I have a feeling this is not going to be the solution you were looking for, but you didn't provide much information to go with to suggest some options. If you're only needing to split up that one specific header and the header name is static to your example, I couldn't see why just renaming that field to what you want and then using a Formula tool to create your new field. You mentioned (or started to mention) that the data doesn't matter so not sure what should go into it so it's just creating an empty value.

If this is not the solution you were expecting, can you provide more details? An example of what your expected output is also helpful.

Best,

Jimmy
Teknion Data Solutions

[barbaracnx]

@JS420 This looks great! Will this continue to work when the column header changes from "1906" to "1907"

[barbaracnx]

@jrgo 

This would work except the header will change from "1906" to "1907" and so on, I need something that will split the header into 2 columns everytime so that I always have a column with the header being "xxxx (what ever the number is) Base Case"

[JosephSerpis]

Hi @barbaracnx it should do as in the text to column I spilt using f so will create two columns from that point on.

[barbaracnx]

@JosephSerpis 

I think the only problem with this is that I have several other columns in my data, so I can't transpose the data like that because it would mess up all the other columns...

[JosephSerpis]

Hi @barbaracnx if it that specific column using a record ID create two streams one with the remaining data and the second stream is where you place the proposed workflow I created to splits the columns then you can join on Record ID with a Join this will ensure the data is not changed. If you are looking at more columns could you provide more details and an example of your data.

[barbaracnx]

@JosephSerpis This is what I have currently. My work flow provides a table that looks like this.

I need to keep everything the way it is, but I need the header of the column of the first row split at 1906.

[JosephSerpis · Accepted solution]

Hi @barbaracnx I've attached a workflow that showcases the approach I spoke about before where essentially you want to separate that first column and then spilt it out with another data stream with the remainder of your data left untouched which is then joined back to the data from the first column once you have successfully spilt the column. Let me know what you think?