Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
I have got a table (see screenshot) and I have column Nr and Description and I want to generate the column Result. Is that possible? The results are different based on the positions.
Solved! Go to Solution.
Good day Moniek,
If the rule is "extract 'P's and digits", this code will extract "Result" from "Description".
= Table.AddColumn(#"Previous Step", "Result", each Text.Select([Description], {"P","0".."9"}), type text)
However, the rule may be stronger than this and may, for example, require digits to be included only if they follow Ps. The finite list of examples aren't enough to deduce it. Nevertheless I hope this helps a bit.
Good day Moniek,
If the rule is "extract 'P's and digits", this code will extract "Result" from "Description".
= Table.AddColumn(#"Previous Step", "Result", each Text.Select([Description], {"P","0".."9"}), type text)
However, the rule may be stronger than this and may, for example, require digits to be included only if they follow Ps. The finite list of examples aren't enough to deduce it. Nevertheless I hope this helps a bit.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
39 | |
20 | |
20 | |
13 | |
13 |