Forum Discussion
replace multiple values list in the same table
Hi dobregon ,
Can you give us the logic? Something like if this then do this, if that, then do that.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
thanks for the refply Nathaniel_C , the logic should be something that search all the numbers in the path and if the number exists (that should be) in the id, the number should be replaced by the numer in the order column
So, the text to analyse is the column path
the oldvalues are in the column ID
the newvalues are in the column Order
Hello dobregon
you can use this formula in your new custom colum
if Text.Contains([Path], [Id]) = true then Text.Replace([Path], [Id], [Order]) else [Path]Have fun
Jimmy
It this helps, consider marking this post as solution or like it
Hi Jimmy801 ,
Where does the three come from in the last row?
NathanielGood question Nathaniel_C
i didn't even look at it.. simple implemented the request specified by dobregon .
Maybe table is wrong or we will get a new logic.. lets wait 😉
Have a nice time
Jimmy
