Forum Discussion

I_NeedMorePower's avatar
I_NeedMorePower
Icon for Helper III rankHelper III
7 years ago

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...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

I believe that PATH returns a string with hierarchy separated by | so perhaps replace || with BLANK().

I_NeedMorePower's avatar
I_NeedMorePower
Icon for Helper III rankHelper III
7 years ago

Hello Mr. Creg,

The Path column displays fine, there are no empty spaces in the path string.

 

Thanks.