When you want to apply a small tweak to the document, it must not require much time to Modify conditional field transcript. Such a basic action does not have to require additional training or running through guides to understand it. Using the appropriate document modifying instrument, you will not take more time than is necessary for such a quick change. Use DocHub to simplify your modifying process regardless if you are an experienced user or if it’s your first time making use of a web-based editor service. This instrument will take minutes to figure out how to Modify conditional field transcript. The only thing required to get more productive with editing is a DocHub account.
A plain document editor like DocHub will help you optimize the amount of time you need to spend on document modifying no matter your prior knowledge about this kind of resources. Make an account now and increase your productivity immediately with DocHub!
hello and welcome back for another video on power query im going to show you how you can replace values in a column and depending on the condition do a replacement and if the condition is not met do something else stay tuned the data set that were looking at is all kinds of restaurants and the data set contains a column that shows whether smoking is allowed for the exercise here we have learned that in the city of tomato malabas if i pronounce it correctly is not allowed to be smoking anymore so whereas it says yes sometimes were not going to want to see no everywhere so to check that the first check that one can do is of course the just for the easiest steps show which of these uh are going to be changed so i could write if state equals to multiples then were gonna change it and else were not going to change it just as a helper column condition true so for each condition that is met here were going to want to change this column here and were going to want to conditionally repl