Forum Discussion
Need Help
Hello everyone,
I’m seeking assistance because I can’t seem to find a solution to my issue. I truly appreciate any time and help you can provide to address my request.
Thank you in advance for your support!
Here are my data. For each material, I have its description and the name of its component.
Material | Description | Raw Mat |
A | Product A | B |
B | Product B | AA |
C | Product C | D+E |
E | Product E | BB |
What I would like to achieve is the following result: When I select a finished product, it gives me the details of the operations to perform and the components to use. I would like a table like the one below:
Material | Description | Raw Mat | RM Des | RM Raw Mat |
A | Product A | B | Product B | AA |
C | Product C | D | Raw Mat | |
C | Product C | E | Product B | BB
|
Hi Semaj06Fr
Please try this:
Here's the sample table:
Click Transform data in the Home pane to use the power query:
Then add a custom column in the Add Column pane:
Text.Split([Raw Mat],"+")Click Expand to new Rows:
Click Merge Queries in the Home pane:
Select the Custom column from the original table and Material column from the current table.
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hello. Just to follow
Hi Semaj06Fr
Please try this:
Here's the sample table:
Click Transform data in the Home pane to use the power query:
Then add a custom column in the Add Column pane:
Text.Split([Raw Mat],"+")Click Expand to new Rows:
Click Merge Queries in the Home pane:
Select the Custom column from the original table and Material column from the current table.
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
