Forum Discussion
Helper VSearch for text in Value and replace with Value from another column in another table
here is a sample that does step one
it matches the names to the user id's in the first table
https://drive.google.com/file/d/1FRtRi_075qeoqPkiGYVnhjimVhzSZFGN/view?usp=sharing
I won't try to explain the steps here. If you'd like to do a session and go over them email me at ken at 8thfold dot com
Solution Sagehere is a sample that does step one
it matches the names to the user id's in the first table
https://drive.google.com/file/d/1FRtRi_075qeoqPkiGYVnhjimVhzSZFGN/view?usp=sharing
I won't try to explain the steps here. If you'd like to do a session and go over them email me at ken at 8thfold dot com
Solution Sagea short youtube to try to explain the steps i took https://youtu.be/-7UuOb7kPJQ
- kentyler
this is as far as i'm going to get today
you can see that we manage to replace the codes by looking up the names
next step will be to coalesce the words back into a sentence- kentyler
OK
I was able to get a little further with another calculated column
and this measureFull String =VAR row_id = Comments[ID]VAR result = calculate(CONCATENATEX(Comments,Comments[Name_for_ID] & " "),all(Comments),Comments[ID]=row_id)RETURN result
and then we let a table graphic work its magic to eliminate the duplicates- kentyler
Here's a short Youtube trying to explain what I did https://youtu.be/NwCFKaWYwAU