Hello again.
There is a field named “Ticker” inside my csv data file, which has got multiple details inside it in the form of a “Large String Value”, which is actually a combination of 6 different parts combined together into one. My purpose is to break this field down into those 6 parts again.
The details of these 6 individual parts is as follows –
1. STRING – This is actually the NAME - WITHOUT ANY SPACES
2. DD – First two digits of the Date
3. MMM – First three characters representing the Month
4. YY- Year in two digits format.
5. STRING – This is a NUMBER which MIGHT HAVE DECIMAL VALUES as well in some cases.
6. CE or PE – This is the prefix, which will either have “CE” or “PE” Values at the very end
To give PRACTICAL EXAMPLE, the Original Ticker Value of ACC26NOV201600CE will get broken down into these 6 New Fields -
1. ACC
2. 26
3. NOV
4. 20
5. 1600
6. CE
BAJAJ-AUTO31DEC203000PE, will get broken down into these 6 New Fields -
1. BAJAJ-AUTO
2. 31
3. DEC
4. 20
5. 3000
6. PE
And so on, for all other values.
Can someone please suggest which method to use for breaking up the Original Field “Ticker” into 6 New Fields, as described above?
To make it easy for you, I have attached the sample data "20201123.csv" file on which this flow needs to be run. Although the actual data file is quite big, having millions of rows in it, but I have made a very small sample out of it for sharing on the forum. All this data has a constant schema throughout.
I have also attached the Alteryx Worflow Package .yxzp file, so that you can easily open it up on your machine. I have used the latest version of Alteryx for creating this workflow. You may please have a look.
