In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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
Top Solution Authors