Dividing Columns based on another column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Alteryx Community,
I am new in to Alteryx but have a good background of SQL.
I have an excel file containing a column which has SKU level of different components and in next column I have the component name.
I need to create different columns based on SKU level (like L1 - L6) each having populated by there respective component name.
Below have attached a screenshot of input and output data.
I would really appreciate it if this could be done in a easy and simple to implement way.
Thanks in Advance for the help.
Solved! Go to Solution.
- Labels:
- Transformation
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @mrai02
One way of doing this.
If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Felipe_Ribeir0
Thanks for the solution. it's working with my format. Thanks for this simple and easy to apply solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Felipe_Ribeir0
Thanks for solution. The solution is working for my format. Thanks for this simple and easy to apply solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
