First I'm using regex parse method to split the dataset into several columns and collect only usefull informations, my pattern is :
(\d+)(.+)\s(\w+)\s\((\d{4})\)\s\w{3}:(.+)\s\w{3}:(.+)\s\$(.*)million,\s\$(.*)million,\s\$(.*)million,\s\$(.*)million,\s\$(.*)million
Then I'm using regex tokenize method to rename column
dynamically, my pattern is :
([^|]+)
![Capture.PNG Capture.PNG](https://community.alteryx.com/t5/image/serverpage/image-id/319663i138E8BDADB1B2B15/image-size/large?v=v2&px=999)