Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Report table tool

knozawa
11 - Bolide

Hello,

 

I am using a report tool (Table) to create PowerPoint.  I have one Name and one Value fields. Is there anyway to create three columns with only values?

 

Example:

Raw data

NameValue
A1
B2
C3
D4
E5
F6
G7
H8
I9

 

Desired Output:

159
2610
37 
48 

 

Sincerely,

knozawa

3 REPLIES 3
MSalvage
11 - Bolide

@knozawa, 

 

Definitely not the most elegant solution, but I think it should get the job done. I did not find a way to use the Report(table) tool to do this so i just reorganized the data using other tools.

 

Note: You may have to do some sorting to get it in the order you want.

 

Good Luck, 

MSalvage

AdamR_AYX
Alteryx Alumni (Retired)

Check out the make columns tool.

 

MakeColumns.png

I think it does exactly what you need.

 

Workflow attached.

Adam Riley
https://www.linkedin.com/in/adriley/
JohanRanschaert
8 - Asteroid

HI,

 

I like this Make Columns tool.

How can I add this in my toolbar?

 

Regards,

 

Johan

Labels