Forum Discussion
Triming unwanted data and create another field
Hi Anonymous,
if you only want to cut the "Q...-" text in your column. You can:
1) go into the query editor
2) click on "Split column" -> "by delimiter"
3) "select or enter delimiter" --> "--custom--" --> -
4) "Split" --> "at the right-most delimiter"
5) ok
And this is the result:
Let me know if it works.
#I'M Not An Expert#
Do all the steps above, but first duplicate the column. Then split the duplicated column as suggested and leave the original alone and you'll have both.
Hi Anonymous,
if you only want to cut the "Q...-" text in your column. You can:
1) go into the query editor
2) click on "Split column" -> "by delimiter"
3) "select or enter delimiter" --> "--custom--" --> -
4) "Split" --> "at the right-most delimiter"
5) ok
And this is the result:
Let me know if it works.
#I'M Not An Expert#
- tjd
Impactful Individual
To avoid the zig-zag and get proper order, change (or add a field) to Year-Qtr (2015-Q1, 2015-Q2, etc.). It will then sort properly on the x-axis.
Appreciated your support, but if I want keep existsing column and create another fields like Qtr and Yr seperately.
The solution what you have provided is splitting the column.
Any possibioities.
Do all the steps above, but first duplicate the column. Then split the duplicated column as suggested and leave the original alone and you'll have both.
