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