Hi
I have converted pdf into Excel then taken extract into alteryx but the data is not coming as required
As the fund and numeric values have merged into similar column.
What i want is to have 3 different Columns
Namely
Income fund
62%
0%2
and same goes for the second row.
Thanks in advance 🙂
Hi @Tid14
Here is how you can do it using regex tool parse mode.
Regex: (.+)\s(\d.+)\s(\d.+)
Workflow:
Hope this helps : )