Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Custom Visuals Ideas will be in read-only beginning Friday, Feb. 28 as we prepare to move these ideas to the new Fabric Ideas.

pb1051

Allow query folding on trim and clean steps

Submitted by Advocate II on ‎08-18-2022 10:51 AM

I have a database that has extra spaces in the data at the end of some columns. I need to TRIM and CLEAN these columns, but now I cannot query fold back to the source SQL server. It would be great to be able to have this solved for the native query.

Status: New
2 Comments (2 New)
Comments
jakaihammuda
Helper III
Helper III
‎03-12-2024 03:57 AM

Hey, 


Did you ever find  solution to this? 

pb1051
Advocate II
Advocate II
‎03-12-2024 06:44 AM

They needed to fix it in the source so that I could remove the steps on my end. Trim should fold but clean does not.