Forum Discussion
Using PATH(), How Do I Remove Blanks From My Hierarchy Between Levels?
Hello awesome communty! I'm learning the PATH() function, what I'm doing is, I want to create a product category hierarchy, I'm getting a table from Dynamics 365 F&O called "RetailProductHierarch...
I believe that PATH returns a string with hierarchy separated by | so perhaps replace || with BLANK().
Hello Mr. Creg,
The Path column displays fine, there are no empty spaces in the path string.
Thanks.
