This content has been marked as final. Show 2 replies
I am trying to figure this problem out with a load script which I currently have.
One of the field in the table is known as date.
2015 Q1 FC
2015 Q2 FC
2015 Q3 FC
2015 Q4 FC
2015 Q1 FC pm
2015 Q2 FC pm
2015 Q3 FC pm
2015 Q4 FC pm
2016 Q1 FC
2016 Q2 FC
2016 Q3 FC
2016 Q4 FC
I would like to extract the dates starting with the Q1-4 into one a field, and another field with the Q1-4 FC PM.
the pseudo code and syntax which i am trying to use is this:
if(subfield(date, ' ',2)="*Q*", keep the selected values) as financial quarter FC
Your help with this matter is greatly appreciated!