Hi,
I am new to Alteryx and need help with the below scenario where the data has successive delimiters. I have data in one cell delimited by many underscores (40 to be precise) that I need to be put in other columns.
Data in cell:
abc
________________________________________
date
text_filter
________________________________________
date2
text_filter2
How I want the output:
column1 | column2 | column3
abc | date | date2
| text_filter| text_filter2
Thanks in advance!
Solved! Go to Solution.
Hi @spamarthy ,
Can you attach file with sample data ?
Hi @spamarthy
See if this solution helps you out... note that when looking at the results in an Alteryx Browse, it only shows the first line, but if you look at the cell using the "Cell Viewer", you'll see that it contains the remaining value on a new line as you specified in the Expected Output in the sample file.
Hi @spamarthy ,
This is another option similar to @jrgo's solution .
Thank you @Jrgo, it is what I was looking for!
Thank you @Benakesh your solution worked as well!