Hello there,
Is there a way to refer to a query to make lots of substitions? Here is an example...
A query with a list of misspelt words and their correct spelling.
The second query has sentences. Some have misspellings, some dont.
I'd like to substitute the incorrectly spelt words in the sentence query, looking up the 'old' column in Replace and replacing it with the word in the 'new' column.
I'm new to PQ, had a stab myself with the embarrasing effort of = Table.ReplaceValue(#"Changed Type",Replace[Old],Replace[New],Replacer.ReplaceText,{"Sentence"}). Obviously PQ told me I was stupid, I am, but I'm keen to learn!
Sincerest thanks for any help that can be given.
Is there a way to refer to a query to make lots of substitions? Here is an example...
A query with a list of misspelt words and their correct spelling.
The second query has sentences. Some have misspellings, some dont.
I'd like to substitute the incorrectly spelt words in the sentence query, looking up the 'old' column in Replace and replacing it with the word in the 'new' column.
I'm new to PQ, had a stab myself with the embarrasing effort of = Table.ReplaceValue(#"Changed Type",Replace[Old],Replace[New],Replacer.ReplaceText,{"Sentence"}). Obviously PQ told me I was stupid, I am, but I'm keen to learn!
Sincerest thanks for any help that can be given.
