This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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"
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.
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?