Forum Discussion
Conditionally Replace Values
Hi all, I have two columns consisting of article numbers and a column that indicates if the article is sold online or not. Articles sold online do not have an article number. So I want to replace...
Please try this line if that doesn't work. Make sure the LeadingArticleNumber column is Text (or use Replacer.ReplaceValue).
= Table.ReplaceValue(#"Uppercased Text","Online", each [LeadingArticleNumber], Replacer.ReplaceText,{"ArticleNumber"})
Regards,
Pat