Forum Discussion
Function to trim the values
You can also click edit queries-> Transform-> Split Column by delimiter and input the custom delimiter "-" like below:
Then remove the useless columns in the splited columns:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Uma_Dhandpani ,
you go to the query editor and use the "add column by example feature".
In the new column you write our desired output - the tool will figure out what you want.
Please mark my post as the solution and share some kudos if it was helpful.
Hi,
I have a doubt that whether it is applicable for 'n' number of values and also for autorefresh data
You can also click edit queries-> Transform-> Split Column by delimiter and input the custom delimiter "-" like below:
Then remove the useless columns in the splited columns:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I need to tell you that I use this for N number of values and for autorefreshed data :smileyhappy:
But I don't know your data so you maybe right but in my experience this worked -> since this feature is just "guessing" the right function based on your input