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 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!
Oh I see, and you're looking to change the names. In this case, you should look into the Dynamic Rename tool. If you give me a bit more detail about exactly how you'd like to change the names, I can whip together an example for you. In general though, Dynamic Rename allows you to use expressions to rename fields, or pass a second input to use as field names.
As for having separate outputs for different rows, I think your best way to do this is the RecordID tool followed by a filter, You could filter on:
In which case the T anchor would have records 4-6, while the F anchor would have records 1-3
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: