Hello,
I have a single field of data (let's called it Format) which comes in two format:
| Format |
USD123456.00 |
200115USD1234567.89 |
Essentially, for the above two formats, I want them to be parsed into three columns:
i.e for USD123456.00 this would be:
- USD would fall into a Currency Field
- 123456.00 would fall into an Value Field.
And for 200115USD1234567.89
- 200115 would fall into field called Date
- USD would fall into a field called Currency
- 1234567.89 would fall into a field called Value Field
Simply, put there should be three columns that should only be outputted.
Example:
| Date | Currency | Value |
| | USD | 123456.00 |
| 200115 | USD | 1234567.89 |
But also worth bearing in mind is that, sometimes a data-set will only have the Format field in 200115USD1234567.89 only, but should be made to be prepared for the possibility of USD123456.00.
I've taken a look at this example: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Parse-name-out-with-2-different-formats-in-a-field/td-p/312882
But it appears to only work when outputting into 2 columns?
Thanks for any help!
