Forum Discussion
Condition a column
Or simply apply a Replace Values step to the column "Value 2".
Table.ReplaceValue(PrevStepName,null,each [Value 1],Replacer.ReplaceValue,{"Value 2"})I hope this is helpful
I don't recognize this logic:
PrevStepName
That PrevStepName reference needs to be replaced with the previous step name from the Applied Steps. If you are unfamiliar or unable to pass it succesfully - try this approach:
1. In the Applied Steps pane, select the step where you want to insert this code (typically, that's the last step you see there)
2. Press the fx in front of the formula bar - this will insert a manual step for you - AND return the previous step name.
3. Copy this step identifier from the formula bar and insert it in the place of the PrevStepName within the provided code.
4. Now you can copy and paste this updated expression back into the formula bar
I hope this is helpful
