Forum Discussion
relation comma seperated fields
Hello All, I'm quiet new to PowerBi and looking for some guidance on the following case: I have 2 textfiles: Groups: GroupID,GroupDisplayName 554dc39f-a4a2-422d-b298-c3eb1fdb66fe,GroupN...
In power query, if you split the column CaUserGroupsInclude(split column by delimiter, on ',' using split to rows)
the relationship will work.
You might have to Clean or Trim the column if there are extra spaces.
Tnx for your reply!
The result is this:Would it be possible to have the groupnames in the same field per policy?
Like this:Ca Policy GroupIDs GroupDisplayNames CA Policy 1 554dc39f-a4a2-422d-b298-c3eb1fdb66fe,36c718d4-3ee5-42c6-a524-6c5461d61e93 GroupName4
GroupName1CA Policy 2 4d502719-f081-47c7-a263-b51a9699408e,1f452b67-77b9-43cc-aa52-82fb931b4546,36c718d4-3ee5-42c6-a524-6c5461d61e93 GroupName3
GroupName4GroupName2
CA Policy 3 554dc39f-a4a2-422d-b298-c3eb1fdb66fe GroupName1
