Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Need help

RE5260
8 - Asteroid

Hi All,

 

Need help here. Workflow attached.

 

I have 1 column, I wanted multiple column based on some certain value.

3 REPLIES 3
CoG
14 - Magnetar

Here is a sample workflow that should do what you're looking for. Uses Multi-Row Formula Tool and Cross Tab Tool:

Need Help.png

RE5260
8 - Asteroid

Hi AndrewDMerrill

 

It's not the output what I'm looking for. I have updated a text input tool stating Expected output.

There will be 5 data values on every products, rest numbers will not be needed.

CoG
14 - Magnetar

That's an easy fix. You only need to add a Sample Tool, grouped by [Name] after the filter tool.

 

You could also just sample at the end of the workflow (after the sort). However you'd like to do it. (Included in workflow below)

Labels
Top Solution Authors