Combine column with first row of data to create new column

Is it possible in Alteryx Designer to be able to combine columns with the first row of data? So if my first column is LastName, and in the first rwo, the data contains Smith. How can I have it so that the column now displays LastName ; Smith instead of just LastName? I have attached a screenshot of what I am trying to do. Any help would be greatly appreciated.

Thank you

Combine Column with 1st row of data.PNG

Workflow

Accepted answers

danrh

You could look at using Transpose to get the column names and values side by side, use a Formula to combine the two, and then a Dynamic Rename back to your original data. Something like:

The first record gets sent to the bottom stream, the rest go through the top stream. Take a look, see if it helps.

solution.yxmd

danrh

Chances are that your field isn't big enough. Put a Select tool just before you merge the column heading and the first row (after you Transpose) and increase the character limit. If you look back at my first response, I added the Select tool for that same reason.

danrh

Add a Select tool and de-select all the fields you don't want in Excel, then drop an Output Data and specify the file/location.

All comments

unknown

Hi Chirag,

Good question! If I understand your question correctly, it's fairly easily done using the multi-field formula tool. I've attached an example of how to do that.

Column names in data example.yxmd

danrh

You could look at using Transpose to get the column names and values side by side, use a Formula to combine the two, and then a Dynamic Rename back to your original data. Something like:

The first record gets sent to the bottom stream, the rest go through the top stream. Take a look, see if it helps.

solution.yxmd

Chirag_Gandhi07

@danrhThanks for your solution. The problem is that I have 120 columns and I only want to join the column name with the first row for about 80 of those columns. When I tried your solution, the columns wouldn't take the first row data. Not sure why.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703