Conditionally Replace Values

[dats]

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 the value in Article Number based on if it was a sale online or not.

Ths is what I am using currently which doesn't seam to work as the article number for online sales is still empty/null

Table.ReplaceValue(#"Uppercased Text",each [ArticleNumber],each if Text.Contains([Source.Name],"Online")=true then [LeadingArticleNumber] else [ArticleNumber],Replacer.ReplaceText,{"ArticleNumber"})

If I add a custom column it works exactly as I would expect it. 

= Table.AddColumn(#"Filtered Rows2", "Custom", each if Text.Contains([Source.Name],"Online")=true then [LeadingArticleNumber] else [ArticleNumber])

the custom coulmn now has the same value for ArtcicleNumber as the LeadingArticleNumber when it is an online sale. 

No I am wondering wh does the conditional replacement doesn't seam towork?

[mahoneypat]

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

[BA_Pete]

Hi @dats ,

Difficult to say without being able to see the data that you are applying this to, but the first thing I would try is to change

'Replacer.ReplaceText,{"ArticleNumber"})' at the end of your replace step to

'Replacer.ReplaceValue,{"ArticleNumber"})'.

Also, FYI, you don't need "=true" after the Text.Contains() function, it evaluates to boolean.

Pete

[dats]

hi @BA_Pete 

Thanks for the hint regarding "true" ou are right that was probably there from some test I made. 

I should have added that the ArticleNumber columne is a text columne. Was this what your tip is based on? But I will try regardless.

-dats