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 would like Alteryx to assist in helping me obtain an output of something like the below table, but I can't seem to figure out how using delimiters/cross tabs, etc. just because there seem to be multiple variables within the list. Thanks in advance for your help!
Monday, May 7, 2018 5:56:22 PM
Seller change 5/7/2018: Message 1: change made to seller name
This is also part of the message column.
Folder 1/File 2
Folder 1/File 3
Thursday, May 3, 2018 3:30:10 PM
Customer change 5/3/2018: Message 1: Customer request - update Address to New York, NY 10002
I'd suggest playing around a bit with different bits of regex. What can often be quite good is to split everything on new line (\n) into rows (this might mess up you message field though - you could join it back up with a multi-row formula) and then dealing with the different parts separately. In the end you can crosstab your data back into columns.