Finds and replaces values in one table based on values in another table.
FindAndReplace = (InputTable as table, WithInColumnName as text, FindAndReplaceTable as table, optional FindColumnName as text, optional ReplaceColumnName as text) as table
Possible parameters, their types and accepted values.
- InputTable - table
- WithInColumnName - text
- FindAndReplaceTable - table
- FindColumnName (optional) - text - Default value: Find
- ReplaceColumnName (optional) - text - Default value: Replace