Forum Discussion
Community ChampionLimitation on text length when creating relationship?
Thanks for the reply. Given that there is no documented limitation, I took a stab at the data model again, removing any leading special characters from the columns (all of the large text values started with a / ). Once I removed the leading special character, the data model actually self-detected the correct relationship.
So moral of the story - don't have your relationship index fields start with a special character (or at least a /)
Community ChampionThanks for the reply. Given that there is no documented limitation, I took a stab at the data model again, removing any leading special characters from the columns (all of the large text values started with a / ). Once I removed the leading special character, the data model actually self-detected the correct relationship.
So moral of the story - don't have your relationship index fields start with a special character (or at least a /)
Helper IIWhat is the technique to remove all non-alphanumeric characters? In my case it could be many possibilities, so I can't do a simple trim that isolates 1 or 2 characters specifically. Thanks for your help!
- dedelman_clng
"What is the technique to remove all non-alphanumeric characters? In my case it could be many possibilities, so I can't do a simple trim that isolates 1 or 2 characters specifically. Thanks for your help!"
cnpdx that is generally best done in PowerQuery/M. You should probably create a new post with that specific question and the users most familiar with advanced PowerQuery should be able to help.