Changing column names and output data based on specific row numbers

Chirag_Gandhi07

Hi everyone,

I have attached a sample workflow and the excel data file. I am trying to change the column names of my output data to Title 1, Title 2, and so on. However, I want the value to still be abc ; 145 def ; 223 and so on. Is there a way to do this in Alteryx or would I have to manually do this with my excel file by adding a new column? Also, abc ; 145 and jkl ; 125 appear twice for two different emails. I want them to have the same title, so abc ; 145 would have Title 1 and both values would appear under that column for the particular emails they are associated with. I also want to output the data based on specific rows. So I would like to have one output that contains row 1-3 with all the columns, and a separate output that contains row 4-6 with all the columns. I have attached a sample workflow and the excel file I used to input the data into the workflow. Any help would be greatly appreciated!

Alteryxexample.xlsx

OutputData.PNG

tcroberts

Here's an example of what I was talking about:

Also, I'm unsure exactly the processing that needs to be done in your workflow, but I'm fairly certain you can get the same output with a single Cross Tab tool, grouping by email, after you duplicate the SW Title field so you can have it in both name and value, as follows:

Spoiler

Let me know if this works for you,

Cheers!