community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Split column header

Meteoroid

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

 

right now it reads:

 

clipboard_image_0.png

 

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

Alteryx Certified Partner

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

Alteryx Certified Partner

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.

image.png

 

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

Meteoroid

Meteoroid

@jrgo 

 

Alteryx Certified Partner

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

Meteoroid

@JS420 

 

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...

 

 

Alteryx Certified Partner

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.

Meteoroid

@JS420 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.

 

clipboard_image_0.png

Highlighted
Alteryx Certified Partner

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?  

Labels