Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
I don't know the answer but let me give you a tip on how I go about discovering solutions to problems like this. Firstly I make sure the formula bar is turned on. Then I perform steps that I want to use as a starting position. In this case perform the replacer Step and look at the code that is generated. Then add the custom column as you've done before and look at that code too. Finally see if you can work out how to take the column reference from the second step and insert it in the first step. Of course you may need to delete these steps that you created and do it again. The whole point is that the language is reasonably easy to deconstruct if you do it this way and learn ho wit works.
Yes, you can use Replace Values for this, and Imke Feldmann explains how here: http://www.thebiccountant.com/2017/07/23/transforming-a-column-with-values-from-another-column-in-po...
Hi @Dan80,
Have you tried the solution provided above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here.
Regards
Yes, you can use Replace Values for this, and Imke Feldmann explains how here: http://www.thebiccountant.com/2017/07/23/transforming-a-column-with-values-from-another-column-in-po...
Thanks all for your replies - great as always! Imke is amazing and her solution has worked for me. Thanks again
I don't know the answer but let me give you a tip on how I go about discovering solutions to problems like this. Firstly I make sure the formula bar is turned on. Then I perform steps that I want to use as a starting position. In this case perform the replacer Step and look at the code that is generated. Then add the custom column as you've done before and look at that code too. Finally see if you can work out how to take the column reference from the second step and insert it in the first step. Of course you may need to delete these steps that you created and do it again. The whole point is that the language is reasonably easy to deconstruct if you do it this way and learn ho wit works.